+ Start a Discussion
Gaurav RajGaurav Raj 

Building Report

Hi,

Need to create a report which comprise of 3 objects.

2 objects are in Master detail relationship, while the other is having a lookup with one of those 2 .  

 

for eg.

Objects P and Q are in a master-detail relationship, while R is having a lookup with P.

Best Answer chosen by Admin (Salesforce Developers) 
AsiereikiAsiereiki

If "P" is the master, then you can't do it with normal reports. You need joined reports.

 

With joined reports you can join a report of "P" with "Q" and other with "P" and "R".

 

http://help.salesforce.com/help/doc/en/reports_examples_joined.htm

All Answers

AsiereikiAsiereiki

If "P" is the master, then you can't do it with normal reports. You need joined reports.

 

With joined reports you can join a report of "P" with "Q" and other with "P" and "R".

 

http://help.salesforce.com/help/doc/en/reports_examples_joined.htm

This was selected as the best answer
sandeep@Salesforcesandeep@Salesforce

You need to create a report Type firstly. 

A - B - C

 

Here please keep A to C objects super parent to child obect . 

Gaurav RajGaurav Raj

Hi Sandeep,

How can i create  a report type of the form A-B-C when , A-B are in master detail while A-C in lookup relatioship.

sandeep@Salesforcesandeep@Salesforce

Hi Gaurav, 

 

I agreed with Asiereiki. We can not make report type including all these three objects. I have found a link where it is explained that how to join report.

http://help.salesforce.com/help/doc/en/reports_joined_format_overview.htm

Gaurav RajGaurav Raj

Hi Sandeep,

 

i created a joined report, is there any way to get rid of the Those headers which appears

 

 

AsiereikiAsiereiki

You can change the name of the headers clicking on them. Try hiding the details too.