Looking to create a report that will pull in Programs that are empty | Community
Skip to main content
K
KristinaWa1
New Participant
July 13, 2020
Solved

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

  • July 13, 2020
  • 1 reply
  • 682 views

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!

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by AdinaPi1

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

    EXISTS:a:$$EXISTSMOD=NOTEXISTS

    EXISTS:a:$$OBJCODE=PROJ

    EXISTS:a:programID=FIELD:ID

    1 reply

    A
    AdinaPi1Accepted solution
    New Participant
    July 13, 2020

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

    EXISTS:a:$$EXISTSMOD=NOTEXISTS

    EXISTS:a:$$OBJCODE=PROJ

    EXISTS:a:programID=FIELD:ID

      K
      KristinaWa1Author
      New Participant
      July 13, 2020

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

      Kundanism
      Kundanism
      New Participant
      November 5, 2020

      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

      Terms & ConditionsAccessibility statement

      Loading footer...