Report filter not bringing in the correct results on a WITH or WITHOUT Custom Report Type
|Knowledge Article Number||000004402|
|Description||If a report includes a filter on a child object field, the filter will only work for the records of the parent that have a record on the child object.
For example: If you navigate to Setup | Create | Report Types and have a Custom Report Type using a relationship such as the following:
with or without related records from Opportunities (B).
Filtering on the Opportunity Object is not allowed for this report.
If you use the Filter in report: Opportunity Stage equals to Closed Won, the results in the above report type will display the records based on the filter and other based on without opportunity records per the report type.
This is expected behavior.