Exporting content
You can export an entire report, as well as each individual report element, such as a chart, summary table, or cross tab, to several different formats. Exporting content to one of these formats creates a file that can be used by other applications in addition to viewers.
Using viewers, dashboards, and Interactive Crosstabs, you can export report content to the following file formats:
*Microsoft Excel (.xls and .xlsx)
*PDF (.pdf)
*PostScript (.ps)
*Microsoft Word (.doc and .docx)
*Microsoft PowerPoint (.ppt and .pptx)
*Extensible HTML (.xhtml)
Table 6‑1 describes the exporting options available when exporting to each output format.
Table 6‑1 Exporting options for output formats
Option
Description
Auto adjustment for pivot table
Automatically adjusts the exported content for display in a pivot table.
BIDI processing
When a report contains languages that are read from left to right, such as English or French, and those that are read from right to left, such as Hebrew or Arabic, the text from both languages can be presented in the same report in the appropriate direction. This text is called bidirectional (BIDI) text. Select BIDI processing if you have a report in two or more such languages and need the data to be correctly presented in the PDF or PostScript output.
Chart DPI
Specify the DPI at which the chart engine exports the chart component. If you do not specify a DPI, the chart engine exports the image with a DPI value of 192.
Disable Flash animation for printing
Renders Flash content as static images to enable printing.
Disable Print
Disables the option to print the exported content.
Embed HTML
Embeds HTML source code in the output file.
Embedded font
Embeds a font currently being used, in the exported output.
Enable live formulas
Exports live formulas when exporting content from a BIRT report that contains expressions created using EasyScript.
Enable pivot table if it fits in one page
Exports the report as a pivot table, if it fits on a single page, to facilitate data analysis in Excel.
Export charts as images
Exports the chart as an image.
Export file for Microsoft Office 2010/2013
Exports the file so that the output is compatible with features in Microsoft Office 2010/2013.
Font substitution
Substitutes one font in place of another when the original font is not available. For example, the classification of fonts into families ensures that only a sans serif font replaces another sans serif font.
Hide grid lines
Modifies the appearance of exported output such that it resembles the report viewed in viewers more than it does a spreadsheet.
Output to multiple sheets
Ignores existing pagination properties when you export a multipage report.
Page range
Enables you to specify the number of pages to export if you are working with a multipage BIRT file.
Page style
*Auto: This option lays out the data such that the report content fits the width of the output page. Existing pagination properties in the report are not retained in the output file, but the output is paginated.
*Actual size: This option retains existing pagination properties from the original report, causing the font in the output file to sometimes be significantly smaller than in the original file.
*Fit to whole page: This option retains existing pagination properties from the original file in the output file, sometimes shrinking fonts and images to fit content from each exported page on each page in the output file.
Re-paginate while rendering the specified format
Paginates the output for the specified export format.
Render chart in vector graphics
For existing SVG images, selecting this option improves the resolution of the exported image, while maintaining a smaller file size.
Text hyphenation
Enables hyphenation for text that spills over onto the next line.
Text wrapping
Eliminates the need for horizontal scrolling in the exported report.
How to export a report or report element to supported formats
1 Choose Export Content from the main menu or from the context menu of a column. Export Content appears.
2 In Export Content, in Export Format, select a format from the drop‑down list.
3 Select Page Settings to expand it. Make your selection based on the options described in Table 6‑1.
Choose OK.
4 File Download appears, as shown in Figure 6‑1. The default name assigned to the file and the file extension are visible. Choose Open or Save.
Figure 6‑1 Exporting data
When you open the file, the report appears in the export format you selected.