Situation:
- Custom object 'MOP' has a master-detail to Opportunity
- Custom object 'Product Revenue Projection' has a master-detail to 'MOP'
- Custom report type Opportunities with MOP with Product Revenue Projections
I created a report of this type, and did not apply any filters at all.
When I run this report as a system administrator, the report does not return all expected results. Eg. it should display this record, but it doesn't.
When I tried replicating this report in another org with a similar data model, it did not encounter this issue. Any suggestions where to look at/what am I missing?