Loading

Report on Accounts without Opportunities in Professional edition

Дата публикации: Jun 21, 2026
Описание

In Salesforce Professional Edition, Cross Object Filters are not available in reports. Therefore, it is not possible to directly create a report that displays Accounts without Opportunities using standard report filters. The recommended workaround is to create a Roll-Up Summary field on the Account object that counts the number of associated Opportunity records, then filter the report on that field.

Решение

Create a Custom Roll-Up Summary Field on the Account Object

  • Click Setup.
    Salesforce Classic: Customize | Accounts | Fields
    Salesforce Lightning: Object Manager | Account | Fields & Relationships
  • Click New Custom Field, then set the Data Type as Roll-Up Summary.
  • For 'Field Label,' enter Opportunity Count, then click Next.
  • For 'Summarized Object,' select Opportunity.
  • For 'Roll-Up type,' select Count, then click Next.
  • Click Next, then click Save.

 

Create a Report Using the Account Object

  1. Click Reports | New Report.
  2. Select the Accounts Report type, then click Create.
  3. Select the All Accounts and Date fields per your requirements.
  4. Drag the Opportunity Count field into the filter and set the Criteria as Opportunity Count equals 0.

This report displays all Accounts without Opportunities in Salesforce Professional Edition.

Дополнительные ресурсы

Roll-Up Summary field

Номер статьи базы знаний

000381953

 
Загрузка
Salesforce Help | Article