function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Report with more than one Master-Detail field?

I am wondering how to create a certain type of Report in Salesforce, or if it is even possible. I have 2 different custom objects, which each have "Contact" as a Master-Detail relationship. Therefore, a Contact can have many occurances of each type of object associated with it. We'll call them ObjectA and ObjectB.

In the Report wizard, I can create a report "Contacts with ObjectA" or "Contacts with ObjectB", but I am wondering if it is possible to create a report with something like "Contacts with ObjectA and ObjectB"?
My only other option is to make ObjectB have a Master-detail relationship to ObjectA, but that isn't neccessarily an accurate reflection of my relational data.

Forgive me if I am missing out on some key concepts of Salesforce reporting, this part of SF is pretty new to me

Sorry - you cannot do that with our current functionality for a report. 

It's easy, of course, to display two unrelated lists on a page, though.

Hope this helps.

Message Edited by RickyG on 03-06-2008 03:55 PM
We have the same need. Is there an App Exchange reporting tool that would support this functionality by any chance? Thanks,