Activity and opportunity custom report shows different results when compared to standard report.
Custom reports on activity or opportunity works on role hierarchy. In standard report types for activities and opportunities one can bring additional users in who aren’t part of the role hierarchy selected. But with custom report types for activities and opportunities this cannot be done. Users who are not assigned to any role can not be able to view custom activity or opportunity report data.