I need to create a Standard SF Report to display all Clients with no Contacts ? How can I check the criteria in the Report ? I tried few things but it didn't work. Any help on this is appreciated
Create a report on Account and add the cross filter 'Account without Contacts'. It will display all those accounts which are having no contacts.
With the introduction of the Cross Filtering functionality in Enterprise, Unlimited and Developer Editions. These organizations now have access to run a report to identify Accounts Without Contact records. The Cross Filters will permit you to include a sub-scope within an Accounts report to narrow the results to only those Accounts without Contacts.
On your Accounts report, click Customize to enter the Report Builder.
Click on the "Add" Multi-Button and select "Cross Filters."
In the Cross Filter section now displayed, select Accounts without Contacts.
Once in place, it will narrow the scope of the report to only those Accounts lacking Contacts.
Please follow the below link for your requirement.