[SalesForce] Generate a report with account and 2 custom objects

I have 2 custom objects(sales and service) which are related to accounts as a lookup and related to opportunities in a master detail.

i need to generate a report which shows under each account the list of sales and service records.

Not sure how i can build this relationship in report types

Best Answer

You could do a joined report which is just two reports that have common fields. One would be Accounts with Sales and the other would be Accounts with Service Records. You can then group across both blocks with Account name.

Related Topic