Project field on task report question

[Knelis13]

How can I get the Project Manager name to populate on a task-level report? It's not a specific task or project field but I can get it to populate on project reports and not on task reports. 

I've even tried this formula which has worked on project-level reports but hasn't worked on task-level reports:
description=Project Manager
displayname=Project Manager
listdelimiter=<div>
listmethod=nested(projectUsers).lists
type=iterate
valueexpression=IF({user}.{role}="Project Manager",CONCAT({user}.{name}),"")
valueformat=HTML
I know Adobe's focus is more on building APIs with other reporting tools than on actually updating their reporting capabilities, but there has to be a way to do this right?

[skyehansen · Accepted solution]

sometimes when people say "project manager" what they really mean is the project owner. However, since you've given me the text mode you're using, I'll just mention that since you are on a task level report and not a project level report, you would need to add one extra word (and a period) to your listmethod. We have a number of different ways to show it, but I usually will try "listmethod=nested(project.projectUsers).lists" first -- so see if that works for you.

[Knelis13]

Glorious! Thank you so much that pulled in as a column! 

Do you know how to change that text mode into a grouping? I added "group.0." before each line and it didn't like that.

Thank you again!

[skyehansen]

You can't group by a collection. If that is important to you, you should probably just include a custom field on the project's custom form to indicate who the project manager is. if this equates to the project's owner, you can definitely group by that field.

If there are supposed to be multiple project managers per project, this will be another case where you won't be able to group by that field.

[Knelis13]

Good to know, thank you!

Yes in 98% of our cases, the PM is the owner so that could work for the other chart. Is it a text mode grouping or is there a field I'm missing?

Thanks so much for your help with these!

[skyehansen]

if the project owner could work, just type in project owner name when you get to adding the grouping, and it should come right up if you are on a task report.