function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Hi all

I created A,B,C,D,X(JUNCTION ) objects

Relationshipes  are  A -> C -> D , B -> C -> D

X is junction object.

 A-> X <-B

can anyone tell me how to create report using join by using junction object.

Thanks in advance.
Make sure that:
  1. A, B and X objects have "Enable Reports" checked ON in Object Properties. 
  2. Relationships from X to A and B is Master-Detail, and not lookups
If both these conditions satisfy, go to reports, and click on "New", then try to find "A with X with B". Salesforce automatically generates a report-type for junction objects. 

Balaji BondarBalaji Bondar

Create custom report type with X as the primary object and you can add A,B,... objects as child object with required fields.
Please refer : (

Important :
If this is what you were looking for then please mark it as a "SOLUTION" or You can Click on the "Like" Button if this was beneficial for you.