0

We have a great deal of our Accounts with at least one Opportunity that we can use a standard Opportunity report with, along with a subset of Accounts that do not have an Opportunity, which we cannot use that same Report. Our stakeholder has requested that we get the entirety of the Accounts noted above in a single Report. I'd use an Account-based field to bring the Accounts into the Report, and the Opportunity-based field (where the Account has an Opp) to include those Accounts. Being that an Opportunity-based Report would only show those Accounts w/ Opportunity records, zero records would be returned, as many Accounts may not have an Opportunity. I'd appreciate any assistance you may provide. Thank you and have a great day.

1

You can go for a Joined Report - Report Type1 for Accounts and another Report Type2 for Opportunities and set the Common Field Account Name as Summary. enter image description here

Here both reports are summarized by Account Name, It displays Account with & w/o Opportunities.

Else you can achieve this by creating a new Report Type for Account & Opportunities with Object Relationship as "A" records may or may not have related "B" records. This way you can create one report and Summarize by Account Name but it would differ the way it looks compared to the above one. This one would look like simple summary report previous one is joined report with two blocks.

  • I will try option 1, but I cannot use the second option due to the limitation on OR operators in filter criteria of those types of "may or may not" reports. Because I need to filter specific Accounts by Opp field value OR Accounts with an Account value, I hit a block regarding that type of report and the OR operator. – Tamim J Dec 8 '16 at 15:31

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.