Skip to main content

Hello Trailblazers,

 

I created a custom report type with 3 objects Opportunities, Accounts & Account Teams.

I have applied the following filters to return the required opportunities

Opportunity Owner = Joe Bloggs

Opportunity Name = Spring Campaign 23 (all the opps I want have the same naming convention)

 

All fine so far. I then want to add into the report the name of the account team member but it doesn't seem to be possible.

 

There is a standard report type called accounts with account teams that provides the fields in the screenshot.

 

These fields don't seem to be available in the custom report type I have created. (I have checked the report layout view as well and the fields are not there to be added)

 

I need all the elements in the same report because I am potentially using it for some bulk updating via dataloader.

 

How do I get opportunity name, account name and team member name in the same report?

 

Thanks Trailblazers

5 réponses
  1. 2 mars 2023, 15:37

    You actually could also use a temporary roll-up summary and avoid soql all together. You could add a rollup summary on Account to aggregate all the Opportunities where Owner = Joe Blogs and Name = Spring Campaign 23.  You could then run a report on Accounts with Account Team Members and add a filter where this rollup value >= 1, and that should give you all the accounts and account team member information associated with those opportunities