+ Start a Discussion
Ben HeissBen Heiss 

Report Issues

I am having a trouble making a report. I would like to connect the contacts and the opportunities objects through the accounts object. I have a report that has the accounts connected to the contacts then connected to the opportunities. This doesn't return any values because both contacts and opportunities are connected to accounts not each other. I considered creating a look-up field on the opportunity object referencing the contact associated with the account that is connected to the account. I assume there is another way and was hoping for some guidance. Thank you.
 
Best Answer chosen by Ben Heiss
Ben HeissBen Heiss
Found the answer I was looking for on another post. https://developer.salesforce.com/forums/ForumsMain?id=906F0000000kEMDIA2

All Answers

deepak balur 19deepak balur 19
I can think of Joined reports which might help you but not sure of your exact requirements. Create a new report, select Opportunities as the new Type. Select Joined Reports in the next screen. Select the Account and Contact Address blocks on to your report. The driver in this case will be Opportunities. 
Ben HeissBen Heiss
Found the answer I was looking for on another post. https://developer.salesforce.com/forums/ForumsMain?id=906F0000000kEMDIA2
This was selected as the best answer