Viewing: Running Reports and the Report Viewer > Navigating the Report

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:

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

2.     Select an export format from the drop-down. See "Export File Types" lists the export options.

 

Table 0‑1 Export File Types

Option

Format Name

Usage

PDF

Adobe Acrobat

To prevent horizontal truncation of an Ad Hoc report when exported, set the Actual Size option in the Ad Hoc Editor.

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.

Flash

Flash Viewer

Exports the report to the Flash viewer. Does not output an SWF file.

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.

3.     With the exception of Flash exports, save the report in the export file format, for example PDF, or open the report in the application. View Flash output in the Flash viewer.