Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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

Avatar

Administrator

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!👍

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 1

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. 

Avatar

Level 3

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