Differences between Standard and Custom Opportunity Report Types

Territory Management NOT enabled

Depending on the Report Type, you may need to select a Role: 
 

• Standard Report Types on Opportunities allow "undrilled" reports which means it's not necessary to select a Role to get the desired Opportunities.
• Custom Report Type you need to "drill-down" to the right Role, otherwise it defaults to the Running User's Role.

If the Organization has the Opportunity Organization-wide Defaults set to "Public Read/Only" or if the running user has view all data:
 

• A Standard Report Type will show all the Opportunities the Running User can see, and that meet the criteria.
• A Custom Report Type will only show Opportunities owned by a User with the same Role as or a Role below them in the Hierarchy. In this case if the missing Opportunities are owned by a User with a Role higher in the Hierarchy, the Running User will need to click that Role in the Hierarchy selector (this can be found in the report detail page under its name).

In this Sharing Model, if the owner of the missing Opportunity has a Role at the same level as the Running User, they will need to click a higher Role. 

Territory Management enabled

In an organization with Territory Management enabled a Standard Opportunity report shows different results than an Opportunity Custom Report Type (CRT). This is because the Opportunity Custom Report Type (CRT) Report checks the consistency between Opportunity Owner and Opportunity Territory while the Standard Report does not.

• If the Opportunity does not have a Territory set, then the Opportunity won't show up in a Custom Report Type (CRT) report at all.​
• If the Opportunity Owner does not belong to the Opportunity Territory, then the Opportunity won't show up in a Custom Report Type (CRT) report. 
• There are 2 ways the connection between Opportunity owner and Territory can be maintained:

1. Manually set the Territory of the Opportunity to match the owner.
2. If the Opportunity owner:

- has "allow forecasting" checked.
- the Forecast Category is "pipeline."
- the Opportunity is assigned to a Territory.
 

then the Opportunity Owner will be automatically added to the Opportunity Territory. (You can test and see this on the User's Territory related list).

Tip: If you change it back to "closed/lost" then you won't see it in the UI, but we still keep the relationship while this User still has "allow forecasting" checked.