Report to display programs with active projects

Question

Hi WF Community,I'd like to generate a report that shows me all programs that have active projects within them.
* Active projects = project Status not in Deleted, Complete, Scoping Archived
* This must take into account that some programs might have completed projects AND active projects. These programs should show up on my report.
 
I'm thinking maybe this is a project report with an EXISTS in a text mode filter?  We don't deactivate programs, and we're yet to create a custom program Status field.
 
I'll continue to see if I can find a way, but any suggestions are welcomed.Thanks,
Nick

Richard_Le_ · Accepted Answer

Hi Nick,

The below should do it. This will return all programs that have projects within them in active status, regardless of whether or not there are other projects in a closed status within that program

EXISTS:a:$$EXISTSMOD=EXISTS 
EXISTS:a:$$OBJCODE=PROJ 
EXISTS:a:programID=FIELD:ID 
EXISTS:a:status=CUR + ANY OTHER STATUSES THAT REPRESENT ACTIVE IN YOUR INSTANCE
EXISTS:a:status_Mod=in

Best Regards,

Rich

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded