Categories in Text Mode Reporting Nested List

[Mikaela-Newell]

Hi all! I'm working on a project report, and have added a column with the following text mode code:

displayname=People
listdelimiter=<div>
listmethod=nested(projectUsers).lists
type=iterate
valueexpression=CONCAT("• ",{user}.{role}," — ",{user}.{name})
valueformat=HTML

I've used this basic setup in other reports too. It gives me something like

• Design Operations — [user1]

• Designer — [user2]

• Copywriter — [user3]

• Designer — [user4]

etc etc

I'd like it to instead give me

• Design Operations — [user1]

• Designer — [user2], [user4]

• Copywriter — [user3]

Bonus points if you tell me how to put {user}.{role} — in bold!

[skyehansen]

hi, I'm not sure if this is old information to you or not, but your current text mode "iterates" (loops through the entire list of users) and for each user gives you the role and the user name. There's no way to group a set of users under one role name unless you break it apart and iterate for all the roles separately.

This might look like a gigantic IF statement (e.g. If the role = designer, concat the names and separate with commas; If the role = copywriter, concat the names and separate with commas; etc.), or in order to get the role names to bold, you might need to break it up across multiple columns, format separately, and then join them together using sharecol.

[Mikaela-Newell]

Ohhh I see! Makes sense. I'll try this tonight and post an update — thank you!