You can adjust column widths and column order, hide columns, and change the number of rows that appear in the report.
Columns
Follow the steps below to adjust the columns within the report.
Hide and Show Columns
The Columns tab allows you to deselect any columns of data that you don't want to see in your report. You may need a column in a report for a filter or a formula, but if you don't need that data displayed, you can hide the column. It will still be available for filtering and formulas.
- On your report, click the gear icon.
- Click Columns.
- Uncheck any boxes next the columns for which you do not want to see on the report, and then click OK.
- You may go back in and check the boxes that were unchecked to show the columns in the report that are currently hidden.
Move or Resize Columns
You may adjust the size of columns or move them 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 you to show all report data on one page, or to adjust the number of rows per page on your report.
- On your report, click the gear icon.
- Click Paging.
- Make your desired selection, 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 amount of rows per page that will be displayed on each page of the report.
- Check the box next to Show all rows to show every row of data on a single page.