Displaying Specific Roles (in a column) On An Assignment Report

[Eric_D_Miller]

Hello,

I am trying to configure a textmode column to display who is filling certain roles on a project. I have this textmode to get it working on a project report but I am unsure how to tweak it for an assignment report. Here is my code:

description=Team Users
displayname=Creative Roles On Project
link.linkproperty.0.name=ID
link.linkproperty.0.valuefield=userID
link.linkproperty.0.valueformat=int
listdelimiter=<br>
listmethod=nested(projectUsers).lists
name=ID
namekey=assignment.plural
stretch=70
type=iterate
valueexpression=IF({user}.{roleID}="53beed9c004ebf57e7a83caffa893a89" || {user}.{roleID}="58d97b9e004ada7cbf3e81ba6c649a48" || {user}.{roleID}="5d84f13e0063dd16b96fcb0c42f714df" || {user}.{roleID}="5458cd0300113c8b8b5f50f821bc6ddf" || {user}.{roleID}="5ab11c1200734f7fa047c04f062afe57" || {user}.{roleID}="53beee46004f251d355dc780bb32a84a" || {user}.{roleID}="5f6c9d7800186cbf89cec913fc61533f" || {user}.{roleID}="64beb1880006e8ec3ffc3d8e2d3f7834",CONCAT({user}.{name}," - ",{user}.{role}))
valueformat=HTML
width=150

I am guessing it has to do with my listdelimiter but I am unsure what to tweak.

Any help is greatly appreciated!

[skyehansen · Accepted solution]

Hi, this text mode is for a collection of project users on a project. A "listdelimiter" is the separation between your results, when you have more than one result, as is normal for a collection.

In an assignment report, you do have the ability to only have one result (each assignment is made to a single user, and you have the ability to report on the role of that assignment), so a collection column isn't necessary, unless for some reason your goal is still to list the rest of the project team per assignment.

And, while it's possible to set up something that would indicate the role of the assignment in a column, it's just as easy (easier?) to simply filter for the 8 roles that you want. 

Can you clarify what you're looking for in this particular assignment report? i.e. are you pulling in unrelated assignments and thus need to only display specific roles? Otherwise, maybe it's enough to filter and then group by the role with no text mode needed?