Project field on task report question | Community
Skip to main content
K
Knelis13
Level 2
November 20, 2025
Solved

Project field on task report question

  • November 20, 2025
  • 1 reply
  • 109 views

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?

Best answer by skyehansen

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.

1 reply

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe ChampionAccepted solution
November 20, 2025

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.

    K
    Knelis13Author
    Level 2
    November 20, 2025

    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
    Community Advisor and Adobe Champion
    skyehansenCommunity Advisor and Adobe Champion
    November 20, 2025

    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.

      Terms & ConditionsAccessibility statement

      Loading footer...