Exporting a Report

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
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.
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.