I have a user who made a joint report with 4 blocks, all of them on the same report type.
The report type gives access to Opportunities, inner join a 1st custom object (let's call it Custom1), inner join a 2nd custom object (let's call it Custom2).
Each block displays a Sum of a currency opportunity custom field and the name of the Custom2.
The filters are :
All opportunities (org scope), Opportunity.CloseDate = current year, Custom2.Name contains [a country name, different in each block], Custom2.CancelReason__c in (value1, value2...)
Run as admin the report returns the expected records, but run with the user it returns no data at all. Yet I can see relevant sample data in edit mode.
After I checked security on every field and object and share settings I made a SOQL query matching the report fields and conditions. Run with the same user, the query does return the expected results for each block, while the report doesn't.
Also, if I create a report with the same conditions as the ones in a block but not joined, it works. As soon as I define report as joined, even not adding any block, I have no record anymore.
Anyone has an idea what could go wrong ?
Thanks for your help.