Print this page

Report Types Change

Knowledge Article Number 000028627
Description Under certain circumstances, adding a column to a Report can alter the results that are displayed. This is an expected behavior of Report Types that is explained below. 
Resolution When a column from a child or parent object is exposed on a report, it essentially modifies the report type to mandate that this relationship exists in any results displayed.

i.e. when you run a report on Opportunities and expose the Account name field, the report will no longer return any Opportunities without a related Account record. (This is not actually the case for these report types, just an example)

When the only fields being exposed are done so by adding the column to the display (not filtering or summarizing) then that field enacts the report type change noted above. When the details are hidden, this field is no longer exposed and does not mandate the relationship.

promote demote