function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Report Question

Is there a way to set up a report to show all Accounts that do not contain a custom related list?


We have a custom object that is a child of the Account, I want to see all the Accounts where there hasn't been any data yet populated in this custom object, so when data is put in there, it will come off of the report.



Best Answer chosen by Admin (Salesforce Developers) 

hi Wayne_Clark,


Create a roll-up summary field on Account with 'COUNT' as type and 'My Custom Object' as summarized object.

This will return 0 if there are no child records of 'my custom Object' for Account.


In the report, add a filter criteria 'My roll-up summary' = 0.

This is return all the Accounts which has no child records.