Report on all users assigned in a project?

[hilk_]

I'm trying to build a project report that includes a column listing all project assignments. I've yet to find the right field to pull. Is it possible in a more creative way?

[svetlanasilina · Accepted solution]

Hi Lyndsy! If I'm reading your question correctly, you'd like to run a project report and have a column that lists the project team for each project. This would add all users that are associated with a project and listed under the People area of the project. Is that correct?

You could follow these steps to do that using text mode:

1. Create a Project report with the required filters, views and groupings
2. While adding the report, add a column to the View, select the column by clicking on the column header and switch to text mode
3. Paste the following code into the text mode and Save the report

description=Team Users

displayname=Project Team

listdelimiter=<div>

listmethod=nested(projectUsers).lists

textmode=true

type=iterate

valueexpression=CONCAT("* ",{user}.{name})

valueformat=HTML

NOTE: You can remove the * that shows up as a bullet for each name by removing the "* ", part of the code.

I hope that this helps to resolve your obstacle!

[hilk_]

Thank you! That worked perfectly.