You need to sign in to do that
Don't have an account?
Sweta_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.
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