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.

[ryanbrogz]

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?

[ChanceBj · Accepted solution]

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=Projects

listdelimiter=<p>

listmethod=nested(program.projects).lists

textmode=true

type=iterate

valuefield=name

valueformat=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.

[ryanbrogz]

That was it, thank you! I could have sworn I tried that very same thing, but I guess not. Thanks again!