I have the following text mode for a column in a project report that populates the entire project user list. I am looking for help on how to adjust this to include only the project user with the job role of designer.

[PamelaMi]

displayname=Project Users

listdelimiter=<br>

listmethod=nested(projectUsers).lists

textmode=true

type=iterate

valueexpression={user}.{name}

valueformat=HTML

[AdinaPi1 · Accepted solution]

I got this to work on my project report. You can also use {roleID} instead of {role}.{name} if you want.

displayname=Designers

listdelimiter=<br>

listmethod=nested(projectUserRoles).lists

textmode=true

type=iterate

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

valueformat=HTML

[PamelaMi]

Perfect! Thank you Adina! Appreciate the help.

[PamelaMi]

Hi Adina,

You helped me with this text mode a few weeks ago and it's worked perfectly. Do you know if there is a way to add to this to make this column sortable in my report view?

thanks in advance. 🙂

Pam

[AdinaPi1]

Hi Pam, I don't know of a way to sort by a valueexpression derived value. Maybe someone else can verify (or has a way).