I have a custom object (Journal__c) which relates to Account. An Opportunity can only reference one Account.

Journal__c has fields: Related_To_Account__c and My_Value__c.

I want a report which shows:

Opportunity Name    My_Value__c
Fred Bloggs-Opp 1   2800
Bill Gates-Opp 3    1967

I have tried creating a custom report type but cannot seem to relate the three objects Opportunity, Account and Journal__c. I thought there would be an obvious join possible from Opp-Account-Journal.

What is the correct way to construct a custom report type which will handle fields related in this way?

1 Answer 1


As the Journal__c and Opportunity objects are both parented by the Account, you cannot create a report type to handle the related objects in the way you are suggesting.


You must log in to answer this question.

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