0

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?

Improve this question

1 Answer 1

Reset to default
0

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.

Improve this answer
2

You must log in to answer this question.

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