Program report pulling number of Projects in Program

[MauraKo]

I have been trying to figure out how to create a Program report that pulls the number of Projects. I have found how to filter to show empty Programs but I can't find a way to pull the number of Projects in a Program. Does anyone have the text mode for how to pull that?

[Kurt_Jones]

Maura, this will give you the listing of projects underneath each Program, I think that is what you were looking for.  I'm not sure you can just get a sum (number) of this or if so I'm not sure how to do it

displayname=Projects
listdelimiter=<p>
listmethod=nested(projects).lists
textmode=true
type=iterate
valuefield=name
valueformat=HTML

[MauraKo]

That worked for my use case, probably even better than just giving me a number too! Thanks for the help!!

[Stacey_Robertson]

I'm not sure if you use fusion - I have fusion count the projects under each portfolio or program and add it to a field on our custom form and then we can report on that number.

[MauraKo]

Ohh we do have Fusion. That's a good idea - I can think of a few other things to with that too! Thanks!!