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
Vaibhab ShahVaibhab Shah 

Report on junction object


I have a requirement to create a report on a junction object.
Say for example there is a standard object A and Standard object B.

Now a junction object is created named C between A and B. Need to create a report on the junction object.


ANUTEJANUTEJ (Salesforce Developers) 
Hi Vibhab,

You can try checking the below link for reference to create a new report type that can be used for creating a new report type for your junction object.


Below are the steps mentioned:

1. Ok, go to setup and search "report types" [[I made a typo in my previous post -- it should be report type]] NOT record type :) sorry!

2. Click new report type

3. Primay object account (select deployed please!)

4. object B: JUNC (select "with at least one related record from.. ")
5. object C: opportunity  (select "with at least one related record from..." )

Now, if you try to create a new report, you will get this report type as a selection. and you will see the relationship as required.

I hope this helps and in case if this comes handy can you please choose this as best answer so that it can be useful for others in the future.