When you have a report open, you can choose to export the entire report or a specified set of pages to Microsoft Excel format.
If you export a crosstab report to Excel, the appearance of the crosstab report in Excel can differ from the DHTML report. For example, the width of a column in the Excel spreadsheet can be narrower than in the crosstab report.
When the report is open, choose Download from the toolbar.
On Download, complete the following tasks:
In Export Report To, select one of the following options:
To export numbers with their data type set to String, select Excel Display, as shown in Figure 2. Using this option does not display Excel row and column headings in the exported report.
To export a tabular or list report, select Excel Data. Using this option exports numbers, retaining their data type information. This option also displays data with row and column headings and gridlines. Do not use this option if the report contains images or a complex format.
In Page Range, select a Page Range option.
figure 2 - Exporting a report to Excel
To save the report in Excel format, choose Save Report.
To view the report in Excel format, choose View Report.