Navigating the Report

Open topic with navigation

Viewing: Running Reports and the Report Viewer > Getting New Perspectives on Data > Moving, Resizing, and Hiding Columns

Moving, Resizing, and Hiding Columns

Columns are easily moved, resized, and hidden in your report.

•

To move a column, click the column you want to move, then drag the column left or right into the new position. The

indicates where the column is placed.

•

To resize a column, click the column you want to resize, then drag the

until the column is the size you want.

•

To hide a column, click the column you want to hide, then move your mouse over the

and select Hide column.

Setting Output Scale

You can determine the display size for any report by using the report scaling options, located in the Report Viewer tool bar.

•

Click

to zoom in on the report.

•

Click

to zoom out on the report.

•

Click

to open the Zoom Options drop-down menu, and select the percentage by which you want to increase or decrease the size of the displayed report.

Using the Bookmarks Panel

When working with a report that contains bookmarks, they are displayed in a floating panel. Using this panel, you can jump to designated sections of the report.

The Bookmarks Panel

•

To display the Bookmarks panel, click

in the Report Viewer tool bar.

•

To jump to a bookmarked section of the report, click the name of the section in the Bookmarks panel.

Navigating the Report

If your report has multiple pages, you can use the pagination controls to move through the report quickly.

To navigate the published report:

•

Use

at the top of the Report Viewer to navigate to the previous page.

•

Use

to navigate to the next page.

•

Use

to go to the end of the report.

•

Use

to go to the beginning of the report.

•

If you know the number of the page you want to view, enter the page number in the Current Page indicator box.

Exporting the Report

To export the report:

To view and save the report in other formats, click the Export button.

Select an export format from the drop-down. The export options are listed in “Export File Types”.

Export File Types
Option	Format Name	Usage
PDF	Adobe Acrobat	Choose a report template based on report size. Use the Actual Size report template for reports with dimensions less than or equal to 14400px by 14400px. See Report Templates for more information.
Excel (Paginated)	XLS	Not recommended for exporting most tables or crosstabs. Repeats headers and footers on each page.
Excel	XLS	Ignores page size and produces spreadsheet-like output.
CSV	Comma Separated Values	Characters outside the Latin 1 character set can cause the Excel spreadsheet to look unacceptable. Try saving the file and importing it using Excel's Import functionality.
DOCX	Word	Do not export reports having more than 63 columns. In Microsoft Word, you cannot create tables having more than 63 columns.
RTF	Rich Text Format	Creates a large output file and, therefore, takes longer to export than PDF, for example.
ODT	OpenDocument Text	For best results, minimize the number of rows and columns and make sure they don’t overlap.
ODS	OpenDocument Spreadsheet	Same as ODT.
XLSX (Paginated)	Microsoft Open XML Format Spreadsheet	Not recommended for exporting most tables or crosstabs. Repeats headers and footers on each page.
XLSX	Microsoft Open XML Format Spreadsheet	Ignores page size and produces spreadsheet-like output.
PPTX	Microsoft PowerPoint Presentation	Each page of report becomes a slide in the PowerPoint presentation.

Save the report in the export file format, for example PDF, or open the report in the application.

Open topic with navigation