Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

A table report is a simple, tabular report that lists application data.

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:

Image

Action

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. The export options are listed in “Export File Types” list below.

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.

Creating a Report

You can create a custom report directly from the Report Center Home page. This method allows you to select an existing Ad Hoc view and generate a report from it, without going through the Ad Hoc Editor.

...