Exporting content to Microsoft Excel
You can use the viewers to export a BIRT report, selected pages of a BIRT report, or a specific report element such as a chart, or cross tab, to Microsoft Excel, Excel 2007, Excel 2010, and Excel 2013. The Excel emitter supports exporting cross tab content as a pivot table. Users who do not have access to Interactive Crosstabs can analyze the exported cross tab output using Excel. If the cross tab contains a grand total, however, the grand total in the Excel pivot table is different from the grand total in the BIRT report. In this case, do not export cross tab content as a pivot table.
When exporting content to Excel 2010, we recommend that you use the XLSX format in order to have access to several features supported only in that format, and to avoid compatibility issues that occur when using Microsoft Office 2010. The exported content in any version of Excel has exactly the same layout as the HTML page in the Viewer.
When you export a cube-based cross tab report to Excel, the Fields pane in Excel displays unused fields in the form dimension@Cube or measure@Cube. These fields represent non-aggregated values and are not used in the cross tab. They can be used in the cross tab without modification.
If you export a cross tab to a pivot table and generate a chart, the chart includes all data in the cross tab. For example, the columns of the cross tab are shown in the chart.
How to export a report or report element to Excel
1 To export a report, or report element, such as a cross tab, or a chart, choose Export Content from the main menu, as shown in Figure 6‑2. Export Content appears.
Figure 6‑2 Exporting a report
2 On Export Content in Export Format, select Excel, as shown in Figure 6‑3.
Figure 6‑3 Exporting content to Excel
3 Select Page Settings. In Page Settings, provide the following information:
1 Select the page range, or specify the page numbers that you want to export.
2 Select Text wrapping to eliminate the need for horizontal scrolling in the exported report.
3 Select Enable pivot table to export the report as a pivot table, to facilitate data analysis in Excel.
4 Select Auto adjustment for pivot table, to enable the Viewers to automatically adjust the content for display in a pivot table.
5 If exporting a BIRT chart:
1 Specify the DPI at which the chart is exported. If you do not specify a value, the Viewers export the chart at 192 DPI.
2 To export each chart as an image, select this option.
6 Select Enable live formulas, to export live formulas when exporting content from a BIRT report that contains expressions created using EasyScript.
7 Select Hide grid lines.
8 To export the output to multiple sheets, select this option.
Choose OK.
4 File Download appears. The default name assigned to the file and file extension are visible. Choose Open or Save.
When you open the file, the report displays in Excel, and can be edited as needed.
Exporting content to Microsoft Word
The viewers support exporting content to Microsoft Word, Word 2007, and Word 2010. When exporting content to Word 2010, we recommend that you use the DOCX format in order to have access to several features supported only in that format, and to avoid compatibility issues that occur when using Microsoft Office 2010.
Exporting content to Microsoft PowerPoint
The viewers support exporting content to Microsoft PowerPoint, PowerPoint 2007, and PowerPoint 2010. When exporting content to PowerPoint 2010, we recommend that you use the PPTX format in order to have access to several features supported only in that format, and to avoid compatibility issues that occur when using Microsoft Office 2010.
When you export content to PPTX format:
*A BIRT table element is exported as a native PowerPoint table if all the functionality in the BIRT table is supported in PowerPoint. Table styles are exported to PowerPoint. Nested tables are supported in BIRT tables but not in PowerPoint.
*A BIRT text component is exported as a single PowerPoint text element if all the functionality in the BIRT text component is supported in PowerPoint. Text components include labels, text controls, and dynamic text controls. For text containing HTML content or dynamic text controls of type html, there may not be a one-to-one mapping between the BIRT text component and the PowerPoint text element.
*In the exported PowerPoint presentation, a slide master is generated based on the settings in the BIRT report design’s master page, including the header, footer, and any other settings that can be applied to the slide master. You retain the look and feel of the rest of the presentation when adding new content and slides to the exported PPTX, and you can modify the header and footer. Page variables, dynamic text controls, and data controls are not supported in the slide master.
*The content is editable by default. If you do not want the content to be easily editable, deselect Edit Mode.
Exporting content to PDF format
You can export report content or report elements, such as charts, or cross tabs, to PDF format. The PDF emitter in the viewers provides consistent layout and pagination properties between PDF and HTML output formats. The PDF emitter also produces a high‑quality PDF file, with a small file size. In addition, it provides high‑quality images for charts, and Scalable Vector Graphics (SVG) format in PDF output.
Exporting content to PostScript format
When you export content to PostScript format, the PostScript emitter displays the content in the output file almost exactly the same way as it appears when printed.
Exporting content to Extensible HTML format
Extensible HTML (XHTML) is the next generation of HTML, compliant with XML (Extensible Markup Language) standards. The XHTML emitter is useful when users need to provide accessibility options for the exported content. XHTML (Extensible HyperText Markup Language) format enables users to access the content from a wide range of applications and is extremely easy to update and maintain.