Apex Code Development You need to sign in to do that
Don't have an account?
Rajkamal 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.
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.
-
A, B and X objects have "Enable Reports" checked ON in Object Properties.
-
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.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 :
https://help.salesforce.com/HTViewHelpDoc?id=reports_defining_report_types.htm&language=en_US (https://help.salesforce.com/HTViewHelpDoc?id=reports_defining_report_types.htm&language=en_US)
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.