You need to sign in to do that
Don't have an account?

how to make a report join two relationship objects
Hi,
We have custom objects, Event, Contact, Account, Event with Contact(master-detail relationship with Event and Contact), Contact with Account(master-detail relationship with Contact and Account). We would like to have a report which show the event with the contacts and its accounts if there is any. Any ideas how to do it? I tried to use join report, and pick two relationship objects, but the contact is not listed as common field. Any ideas?
We have custom objects, Event, Contact, Account, Event with Contact(master-detail relationship with Event and Contact), Contact with Account(master-detail relationship with Contact and Account). We would like to have a report which show the event with the contacts and its accounts if there is any. Any ideas how to do it? I tried to use join report, and pick two relationship objects, but the contact is not listed as common field. Any ideas?