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
Sweta_S_SinghSweta_S_Singh 

Report on Opportunity and Campaign having many - to - many Relationship

I  want to create a many-to-many relationship between Campaign and Opportunity Object and in Report all the opportunities with the corresponding campaigns should come.
Best Answer chosen by Sweta_S_Singh
Raj VakatiRaj Vakati
Create a new Custom report type on the Junction object and pull the related Campaign and Opportunity data 

Many-to-many relationships provide two standard report types that join the master objects and the junction object. The report types are:
“Primary master with junction object and secondary master” in the primary master object's report category.
“Secondary master with junction object and primary master” in the secondary master object's report category.
The order of the master objects in the report type is important. The master object listed first determines the scope of records that can be displayed in the report.
You can create custom reports based on these standard report types. In addition, you can create custom report types to customize which related objects are joined in the report.

refer this link 

https://help.salesforce.com/articleView?id=relationships_manytomany.htm&type=5