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 |
• | To resize a column, click the column you want to resize, then drag the |
• | To hide a column, click the column you want to hide, then move your mouse over the |
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 |
• | Click |
• | Click |
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 |
• | 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 |
• | Use |
• | Use |
• | Use |
• | 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”. |
Option
Format Name
Usage
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.
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.3. | Save the report in the export file format, for example PDF, or open the report in the application. |
Recommended Comments
There are no comments to display.