How to create a report listing all Problem records without any Problem Tasks attached

[victor_b]

Like the title says. I'm a Problem Manager with access to the Problem table and the Problem Tasks table and such, and want to create a report Problem records without any problem Tasks attached.

Is this possible within reporting? I can't seem to find any flags within the Problem records themselves referencing the existence of Problem Tasks attached.

[sushant007]

Hey Ulrich,

In most of the cases creating a custom field on any table is challenged in my organisation and Yes that varies org to org.

We avoid creating the custom fields on form and this is (database view) the way out for us in those cases.

[dmac]

Victor,

There is a very good post about this very thing located here, Identify the groups with just one member . Check out the first reply by Patrick Schulte, he actually outlines how to do it in the report builder.     Instead of using Table>Group, you would use Table>Problem.   Then in the Related List Conditions, you would use Problem Task>Problem.   Click on the text above that field where is says Equal to 1, and select None or Equal to 0, then Run.   That will give you a report of Problems that do not have any problem tasks.  

The DoCS reference is here: Add related list conditions

And check out the section title 'Including a related list query' for a good understanding of how to build these types of queries in a list or script: Encoded query strings

[austinn1]

This should be marked as the correct answer! Also, it is 3 years later now so I'm not sure if this was the case when this post was created, but related list conditions are also available on performance analytics indicator sources!

[Chazz]

I found a solution for this at this location:
How to create a report or a view to show problems (PRBs) that have 0 Incidents or 0 task problems as...

1. Navigate to Reports > Create New
2. Provide the following information:
   
   • Report name
   • Source type = table
   • Table = Problem[problem] (Use whatever table relevant for you)
3. In the Configure Tab:
   
   1. Create a condition in the related list conditions for Problem Task > Problem with the condition "Equal to 0"
      See the following screenshot for more details.
      

      Run the report. This should give you a list of all PRBs with no Problem Task associated with the PRB.