I have a custom object (called Publications), which is related to Contacts through a Publication Contact Relation object, with Publications and Contacts as master-detail fields. I would like to generate a report that shows all Publications for Contacts who are members of a Campaign.

I've created a "Campaign with Contacts" report in joined format, then added report type "Contacts with Publication Contact Relations and Publications", but the only common field is Owner.

Is there a way to create a report that joins all the way through from Campaign to Contacts to a Custom object (Publications, in my case)?

1 Answer 1


Create a custom report type

In Setup, under App Setup, expand the Create section and select Report Types. Create a new report type with Campaigns as the primary object, then Contacts as the A to B relationship, and Publications as the B to C relationship.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .