Columns and Paging in a Report

Adjustments that can be made include column widths and column order, hide columns, and change the number of rows that appear in the report. 

Columns

Hide and Show Columns

The Columns tab allows for the deselection of any columns of data that do not need to be viewed. A column may be needed in a report for a filter or a formula, but if that data does not need to be displayed, the column can be hidden. It will still be available for filtering and formulas.

1. Click Reporting on the upper navigation bar, and then click Report & Data Sets.
2. Click Run Report on a report.
   
   
3. Click the gear icon.
   
   
4. Click Columns.
   
   
5. Uncheck the boxes next to the columns to be hidden on the report, and then click OK.
   
   
   • To show the columns again, check the unchecked boxes.

Move or Resize Columns

The size of columns can be adjusted, and they can be moved to different areas in the report. 

• Click the left side of a column to drag and drop the column elsewhere in the report. 
  
  
  
• Click the right side of a column and drag it in either direction to make the column larger or smaller.
  

Paging

Paging options allow for all report data to be shown on one page and for the number of rows per page on the report to be adjusted.

1. Click Reporting on the upper navigation bar, and then click Report & Data Sets.
2. Click Run Report on a report.
   
   
3. Click the gear icon.
   
   
4. Click Paging.
   
   
5. Enter a paging option, and then click OK.
   
   
   • Check the box next to Show all rows to show every row of data on a single page.
     
     
   • Check the box next to Show paging and change the number of rows per page that will be displayed on each page of the report.