function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Vaibhab ShahVaibhab Shah 

Report on junction object

Hi,

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.

Help.

Rgds,
Vai.
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.

>> https://trailblazers.salesforce.com/answers?id=9063A000000p8dtQAA

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..." )
Save...

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.


Regards,
Anutej