You can easily configure a column to be hidden by default when a report is run. A hidden column won’t display on the report, but can still be shown if desired via the Report Viewer’s right-click capabilities.,
Follow the steps below to hide a particular column by default.
Select Reports > Builder.
Use the Show All button to view all custom reports. Or use the Search field to further drill down your search.
Select the Report from the list.
Right-click on the field after it has been dragged onto the Columns pane and select Hide column from the menu list.
Check Your Understanding:
Under what situations would someone want to hide a column on their report instead of simply removing it? There may be many different scenarios in which hiding a column(s) on the report would be more beneficial than removing it, but the 2 most common reasons are:
- You use a column in some situations when running the report but not all the time. If this is the case, hiding the column prevents you from having to create 2 separate reports.
- You are using the column as part of a Calculated Column, but all you care about is the resulting calculation. In this case, the column is necessary for other columns (and needed on the report), but in itself may not be useful to you.