I have a custom object (Journal__c) which relates to Account. An Opportunity can only reference one Account.
Journal__c has fields:
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
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?