You need to sign in to do that
Don't have an account?

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.
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.
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