0

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

  • 1
    What is Client? – kurunve Aug 1 '17 at 10:17
  • 1
    Are you meant to say Accounts with no contacts? Then Accounts reports should work on this. You could also try custom report type. – user28452 Aug 1 '17 at 10:18
  • yes apologies, I used the renamed term. So I meant Accounts with no Contacts. I added the criteria for All Accounts and Filtered by : Contact ID equals "" (Thinking that this will filter the Accounts which doesnt have a Contact ID) but it doesn't display any records although there are Accounts without Contacts – Tinkerbell Aug 1 '17 at 10:24
  • 1
    You can follow this link: help.salesforce.com/… – user28452 Aug 1 '17 at 10:30
  • @user28452 yes that worked! – Tinkerbell Aug 1 '17 at 11:34
3

Create a report on Account and add the cross filter 'Account without Contacts'. It will display all those accounts which are having no contacts.

On your Accounts report, click on "Add" Multi-Button and select "Cross Filters." and select the above criteria. Please find the attached screenshot for same. enter image description here

| improve this answer | |
-2

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.

  1. On your Accounts report, click Customize to enter the Report Builder.

  2. Click on the "Add" Multi-Button and select "Cross Filters."

  3. 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.

https://help.salesforce.com/articleView?id=000003804&language=en_US&type=1

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.