Skip to main content
Topics#Reports & DashboardsKimberly Phillips's Question
Kimberly Phillips (BCA) asked in #Reports & Dashboards
Feb 22, 2011, 7:51 PM

report of accounts without opportunities

Is it possible to create a report on accounts or any other object that has zero records in a related list? Like Accounts that don't have any opportunities.

 

We have PROFESSIONAL EDITION.

 

Thanks.
12 answers
  1. Steve Molis (You Owe Me a Beer, Inc.)
    Feb 22, 2011, 8:05 PM
    Yes, er... sort of...  you need to create a custom Rollup Summary field on the Account object that returns the COUNT of Opportunties, then use this in your Report Filter.  

     

    Or you could create a Custom Report Type (NOT a Custom Report) and select Accounts with AND without related Opportunties.
Write an answer...
0/9000