Background
I have 3 custom objects:
Invoice__c
Invoice_Line__c
Appointment__c
Their relationships are:
Invoice__c
is a parent (master-detail) toInvoice_Line__c
Invoice_Line__c
has a lookup toAppointment__c
Question
Why can't I create a custom Report Type linking the 3 objects together?
i.e.
Appointment__c
> Invoice_Line__c
> Invoice__c
Or some other combination?
Best Answer
You have to start from the common child object (invoice line), then you can go "up" to both parents. These fields are not shown in the palette by default, but you can add them using the "add via relationship" function found there.