Report - Resolve Problem Record when All Tasks completed

[Prem Singh]

Could someone help,  due to high volume of tracking problem ticket completion , I need to setup a report which generates with Problem Records whereby all Problem Tasks had been completed. This is to ensure I can Complete the Problem Record since Problem records can only be Resolve once all problem tasks are completed.

I setup as per attached pic however the condition works only when either any task is completed but not all. Example Active is False only when any one task is Completed. I need the report to generate the problem record where all tasks are completed.

[Luke Van Epen]

Change the related record condition to be No records match and then the condition is Active = true

[Luke Van Epen]

Should end up like this

[NV]

But this will also display PRBs which have NO PTASKS. 

I believe the Q is , how to list PRBs where ALL PTASKS are closed (implying it has PTASKS).

[Prem Singh]

Luke , thank you so much for your help. It works !