I want to create a report in which it should be retrieving the account team members with his/her related accounts and contacts.

I tried custom report type and joined reports. But couldn't get the intended output.


This answer is specific to Classic.

You may need to create Joined Reports in this case. Refer to the image below as a reference, if that's how you want it.

A joined report by definition states:

The joined report format lets you view different types of information in a single report. A joined report can contain data from multiple standard or custom report types.

In your case, you can create two different summary reports with Account & Contact and Account & Account Team Member report. Then you can join the report and group by say Account Name to be able to present it the way you want.

Additionally, you can create custom report types to have these information captured separately and then join on reports created using those report types.

You can find more on Custom Report Types and Joined Reports in the help article.

enter image description here

| improve this answer | |
  • This is looking good, but I want to have a report of some particular team members and their related accounts and contacts. – ram135868 Apr 19 '18 at 11:19
  • I don't think you will be able to do so using out of the box capabilities. You may like to create custom visualforce page or lightning component for the purpose. – Jayant Das Apr 19 '18 at 12:18
  • you mean , by doing the vlookup stuff in apex ? – ram135868 Apr 19 '18 at 14:28

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.