Exporting Reports in Different Formats and Purpose

You can export a complete document or multiple reports to a text file, a PDF, an Excel spreadsheet, a CSV file, or a CSV archive. If you want to export raw data, only the .CSV format is available. You can select whether you want to export all data or just the data for specific queries. Except for the text file format, each file type has several settings available when you are in the Export dialog box.

To export a report

1. In the File section of the toolbar, click the Export icon to export the reports. Reporter opens the Export to dialog.

Note:In Design, Structure and Data mode, the Export option is available from the More menu.

2. In the Export to dialog, select the file format and specify any export options.

Format

Purpose

Excel

This format is useful if you want to combine the information in the Web Intelligence document with other data in an Excel spreadsheet.
Select the scope of the exported data:
Select Reports to export the reports’ data, and select the reports you want to export.
Select Data to export the document’s raw data, and select the queries you want to export.
If your document contains several reports, you can export all of them or explicitly select the ones to export. Each report is saved as a spreadsheet in the Excel file. You can select between two options:
Select Prioritize the formatting of the document to keep the formatting in the .XLSX file.
Select Prioritize ease data processing in Excel to avoid merging multiple cells into Excel cells as much as possible and benefit from the data processing features of Excel.
Unlike Web Intelligence documents, the Excel files are not connected to the database. You cannot refresh the data in the Excel file. To display up-to-date data in Excel format, refresh the Web Intelligence document and then save it as a new Excel file.
This format does not include the header and footer displayed in the Web Intelligence report.
The charts are converted to images, not actual charts.
If you have used drill functionality, cross-launch and hyperlinks inside the report, export to Excel may not work as expected. The formatting and grouping of the Web Intelligence report is not retained in the Excel worksheet.

Version:In version 4.2, you could choose between export to .XLS and .XLSX. In version 4.3, documents are exported to .XLSX only.

PDF

This format is useful to provide the document in a printable format.
The page layout and formatting of the Web Intelligence report is retained in the PDF file.
The PDF file is the exact copy of the document/report and can be shared to other users (non-BO users) via email, shared location.
Use the Options section to fine-tune the range to be exported, the image quality and set whether to include bookmarks.

HTML

If your document contains several reports, you can export all of them or explicitly select the ones to export.

TXT

The groupings and columns of the Web Intelligence report is retained in the text file. Text formatting is not kept (for example: Header row color).
In page mode, the report elements are exported page by page.
The separator used is a tab space.
Charts and images are not exported.
If several reports are selected, they are appended one after another in the same text file.

CSV

Select the scope of the exported data:
Select Reports to export the reports’ data, and select the reports you want to export.
Select Data to export the document’s raw data, and select the queries you want to export.
The formatting and grouping of the Web Intelligence report is not retained in the CSV file.
Under Options you can configure the following properties:
Text qualifier
Column Delimiter (You can also directly type in a custom character you want to use, such as the pipe (|).)
Charset
3. Click Export.