Another day, another WF reporting question. I'd like to show all Projects within a Program on a Project level report, in the same cell.

Question

I'd like to show all Projects in a Program, in the same cell, on a Project level report because there is some other contextual information all stored at the Project level that I'm sorting on or displaying.

I've seen this done at the Program level (showing all of its corresponding Projects within the same cell) with the calculation below.

displayname=Proejcts

listdelimiter=<p>

listmethod=nested(projects).lists

textmode=true

type=iterate

valuefield=project:name

valueformat=HTML

What am I missing to do this exact same thing, just on a Project level report?

listmethod=nested(projects).liststextmode=truetype=iteratevaluefield=project:namevalueformat=HTML What am I missing to do this exact same thing, just on a Project level report?

ChanceBj · Accepted Answer

Hey Ryan, Give this a try. This should list all projects in the cell housed in the same program, in line with that project. displayname=Projectslistdelimiter=

listmethod=nested(program.projects).liststextmode=truetype=iteratevaluefield=namevalueformat=HTML Since we are at the project level already, I specified to go to program, then back down to projects in the listmethod. The valuefield= line will only need name as well since it's a direct field on the project table.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded