Looking to create a report that will pull in Programs that are empty

[KristinaWa1]

Good afternoon,

I am trying to create a report that will show me programs that do not have any projects opened under it. I took the EXSISTs filter for projects and tried to modify for Program, but I get an error. Does anyone have any insight?

EXISTS:a:$$EXISTSMOD=NOTEXISTS

EXISTS:a:$$OBJCODE=PROJ

EXISTS:a:programID=FIELD:ID

EXISTS:b:$$EXISTSMOD=NOTEXISTS

EXISTS:b:$$OBJCODE=DOCU

EXISTS:b:programID=FIELD:ID

EXISTS:c:$$EXISTSMOD=NOTEXISTS

I am also wanting to create a report that will show me programs that have all of their projects complete or cancelled, but I have not been able to get that to work either.

Thank you!

[AdinaPi1 · Accepted solution]

Hi Kristina, try this for no projects in a program:

EXISTS:a:$$EXISTSMOD=NOTEXISTS

EXISTS:a:$$OBJCODE=PROJ

EXISTS:a:programID=FIELD:ID

[KristinaWa1]

Thank you! That worked. I just needed to add in a filterto remove Inactive ones and I got what I needed.

[Kundanism]

Hi @Kristina Walton‚

Could you please explain how you created this report, for example which type of report + view + grouping + filter, etc.?

Thanks you in advance.

Best regards,

Kundan

[KristinaWa1]

Hi Kundan,

I used a Program report and below is the custom text I used. I have this only pulling in programs that are active:

EXISTS:a:$$EXISTSMOD=NOTEXISTS

EXISTS:a:$$OBJCODE=PROJ

EXISTS:a:programID=FIELD:ID

EXISTS:b:$$EXISTSMOD=NOTEXISTS

EXISTS:b:$$OBJCODE=DOCU

EXISTS:b:programID=FIELD:ID

isActive=true

isActive_Mod=eq

name=Quality

name_Mod=cinotcontains

My report is then grouped by Program owner and I have the Owner, Description and Entry Date showing in the view. But that can all be customized to show the data that you are looking for.

Hope this helps.

Kristina