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.

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.