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