Report View: Is it possible to retrieve a second-level collection?

Hi Chris - Unfortunately, I don't think you can do a collection of a collection.

Now with that said, have you looked at the Project Users (or Project Team as some call it) and see if that helps. The only down side to it is that if someone's tasks is reassigned to someone else, they will stay on the project until the PM removes them from the People tab. But if your users aren't moving people around all the time, that might be close to accurate.

Try this out and see if it works for you :) (For project object type reports)

displayname=Project Users

listdelimiter=<br>

listmethod=nested(projectUsers).lists

textmode=true

type=iterate

valuefield=user:name

valueformat=HTML

Hi Chris,

Another workaround instead of a collection-of-a-collection might be to assume that the primary assignee of each task is "it" as far as that Task's particular role is concerned (using a Quality Assurance role called "QA" as an example), and assuming that only one such task will exist per project (or if not, living with the side effect of having the same person repeat, and/or seeing more than one person):

displayname=QA Task Assignees

listdelimiter=<br>

listmethod=nested(tasks).lists

textmode=true

type=iterate

valueexpression=IF({role}.{name}="QA",IF(ISBLANK({assignedToID}),"",CONCAT({role}.{name}," - ",{assignedTo}.{name})),"")

valueformat=HTML

You could then repeat this approach for a separate column per role (e.g. QA, Chief, Cook, Bottle Washer, etc.)

Mileage may vary.

Regards,

Doug

Hi @Anthony Imgrund‚ and @Doug Den Hoed‚ , thanks you so much for your thoughts on this. Sadly we have quite complex projects with a lot of assignees in different roles. The Project Users include also users that have already completed all their tasks and as you pointed out even those who have been re-assigned in the meantime. But I guess I will look at options via Fusion to get all the assignments and paste that in a field on task assignement updates.