+ Start a Discussion
Wayne_ClarkWayne_Clark 

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.

 

Thanks!

Best Answer chosen by Admin (Salesforce Developers) 
VK86VK86

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.

 

--VK