Project Report - Column for Task user role and name

[DarshanAm1]

I wanted to know if you can generate a column within a project report to show specific user roles who are assigned tasks in the project and then have their name populate in that field. (Example - QA Lead - John Smith)

[lgaertner]

Hello,

I think that will not be possible in general as you would need to query collections in multiple "layers", which could lead to a timeout.

But, as you also can read here, 

• You cannot build a collection view of another collection.
  For example, you cannot display all the assignees on each task in a project report. You can only display the primary assignee on each task in a project view.

---

---

Regards

Lars

[lgaertner · Accepted solution]

Ok, wow...

I think I just accidentally stumbled upon a (partly) solution, when reading this thread.

As all assigned users to tasks under a project can also be queried using the projectUsers collection, you can use something like this:

valueexpression=CONCAT({user}.{role}, " - ",{user}.{name})
listdelimiter=<div>
listmethod=nested(projectUsers).lists
valueformat=HTML
displayname=Assignees
description=Assignees
textmode=true
type=iterate

I am quite sure, that the limitation, you will need to live with is, that you will only get the primary role of the users.

Regards

Lars