I am building the report on campaigns and customobject 01 ,But wen i build the report i was not able to get all the project ID that are associated to the campaigns.
The issue is when i pull the campaign id it wont fetches all the ID for customobject01 (becoz the relation is M:M)
Can u please guide how to build the report.
you can try to add the metric fields to your report for all involved objects, like # of Campaigns, # of Projects and # of Custom Object 1. Afterwards you can hide these fields from layout. For me this has always helped.