I have the text mode below in a project report to show the name of a user with role as designer. Is there code I can add so the report can be sorted by this column?

[PamelaMi]

displayname=Designers

listdelimiter=<br>

listmethod=nested(projectUserRoles).lists

textmode=true

type=iterate

valueexpression=IF({role}.{name}="Designer",{user}.{name},"")

valueformat=HTML

[Doug_Den_Hoed__AtAppStore]

Hi Pamela,

"Nope". Collections cannot be sorted. As a workaround, you could, however, add a custom parameter at the Project Level called "Designer Role", manually load it with the names of the Designers in your company, and then sort (and filter, and group, and chart) by that field.

I've used this technique in the past many times -- one such dropdown for each key role -- and found it to be very useful. In fact, if you make the value of the dropdown the ID of each user, you can even filter on those key role parameters using $$USER.ID, which has even more advantages.

Regards,

Doug

[PamelaMi]

Thank you Doug, I will give this a try.

[PatriciaGr]

You may also try adding User Name as a hidden column and sort on that?