Project Report - People Column | Community
Skip to main content
Level 9
Sep 21, 2016 4:56 AM UTC
Question

Project Report - People Column

I have a project report, and I'm trying to add a column that lists all the people that are involved with that project. It's basically the same list that is in the Staffing -> People tab (project owner, project sponsor, and all assignees). Has anyone done this before? Thanks!
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

21 replies

Level 9
Jul 11, 2017 7:00 PM UTC
Hi Andrew, I don't think you can call a project's collection within a task report but maybe somebody else have tried it. Cheers.
Translate
Level 4
Jul 11, 2017 4:56 PM UTC
This code is great and very helpful Polly! could it be used in a Task report? Andrew Beard Sr. Associate, LeapPoint "mailto:abeard@leappoint.com" abeard@leappoint.com 203-232-4090
Translate
Level 9
Feb 5, 2017 9:24 AM UTC
Karen, this would depend on your project filters. In one way we've used this is sort of to replace the generic Staffing/People tab on a project. See attached. The report itself does not filter to a specific project but when you put the report into a project, it just sees people within the project. I've also used this as a column view in the Project's I Own or Projects I'm On to give me a quick view as to who's who in project before getting into the project itself.
Translate
Level 6
Feb 4, 2017 8:17 PM UTC
Polly, Could you post a screen shot of the report? tks Karen
Translate
Level 4
Feb 4, 2017 1:35 AM UTC
Thanks, Polly!
Translate
Level 4
Feb 3, 2017 7:14 PM UTC
This is great! I was also looking for something like this. Thanks for sharing
Translate
Level 9
Feb 3, 2017 5:55 PM UTC
Michael, the code pulls in project owner, sponsor and task assignees, not shared users. David Cromwell had a post before on how to use nested lists. Hopefully that will help you pick data for other types of reports. https://community.workfront.com/p/fo/st/topic=62&post=726#p726
Translate
Level 4
Feb 3, 2017 4:51 PM UTC
Polly, this is great! Just so I understand the logic, the code is pulling all task assignees along with the project owner and sponsor? Or will it pull in everyone the project is shared with? I was also wondering if there's a way to modify the code to use it on other report types (e.g. issue report, task report, etc.)?
Translate
Doug_Den_Hoed__AtAppStore
New Participant
Sep 21, 2016 4:14 PM UTC
Agreed -- thanks for sharing, Polly. As an aside, the "nested" concept that Polly used is a powerful part of Workfront's textmode feature. I encourage anyone who is striving to get the most of their reports to invest the bit of time it takes to get comfortable with it. Regards, Doug
Translate
AdinaPi1Author
Level 9
Sep 21, 2016 3:47 PM UTC
Thank you, Polly. This is exactly what I needed! I only had to remove the stretch=25 line, it was giving me a pink error message. Adina ________________________________
Translate