function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
AceldamaAceldama 

How to report on Cases without Related Cases

We have implemented a Case process between system teams and want to ensure that certain Case types have a corresponding Related Case.  I need to build out a report to identify Cases that do NOT have a related Case.  Easy enough to report on Cases WITH Related Case information, but the opposite is causing a bit of a problem.

Anyone tackled this issue before? 
Shashikant SharmaShashikant Sharma
You will not be able to create this with report type but you could be do:

1. Create a new field a check box ( Has Related Cases )
2. Write a trigger to populate this field
3. Use this field as filter in your report.