Quick Tip: How to add Portfolios and Programs columns to a Task report | Community
Skip to main content
kynabaker16
Adobe Employee
kynabaker16Adobe Employee
Adobe Employee
June 3, 2021
Question

Quick Tip: How to add Portfolios and Programs columns to a Task report

  • June 3, 2021
  • 1 reply
  • 773 views

Program and Portfolio Owners as well as other stakeholders may find it helpful to group a Task report by Program or Project if, for example, they want to see all of the tasks in a specific program or portfolio that are overdue. To do this, simply edit your report, navigate to the grouping area and switch to text mode. Then paste the following code!

Group a Task Report by Portfolio:

group.0.displayname=Portfolio

group.0.valueformat=HTML

group.0.valuefield=project:portfolio:name

Group a Task Report by Program:

group.0.displayname=Program

group.0.valueformat=HTML

group.0.valuefield=project:program:name

"Like" this post if you find it helpful!👍

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    1 reply

    C
    cma1
    November 14, 2022

    Hi we have several instances where either the program or portfolio is used for different purposes. Is there a way to create conditional grouping?

     

    So if there is no Portfolio associated with that task it will instead pull in the Program. 

    F
    FemkeCr
    Level 4
    November 15, 2022

    I think having a Program without an associated Portfolio is impossible. 

    But if it is, then the grouping text mode would probably be:

     

    group.0.displayname=Portfolio or Program
    group.0.valueexpression=IF(ISBLANK({project}.{portfolio}.{name}),{project}.{progam}.{name},{project}.{portfolio}.{name})
    group.0.valueformat=HTML
    textmode=true

    Terms & ConditionsAccessibility statement

    Loading footer...