Reports can be exported as a file and viewed in a number of applications. An exported file can also be saved to be viewed later or distributed. To export a report, click on the icon that corresponds to the file type.
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. |