Export formats

This topic describes the export formats that are available for sharing reports with colleagues and other Application Studio users.

For a description of the Export Content option, see these topics:

You can export reports to these formats:

PDF

Available for single reports and report books.

MS Excel

Available for single reports and report books in View Mode.

For single reports, select File > Export/Import > Export to MS Excel and select an output format.

For report books see this topic:

Exporting report books.

These Microsoft Excel export formats are supported:

Excel 97-2003 Workbook

Formulas that are specific to Application Studio (for example, ROC, ROA) are replaced by the values which they return. Excel formulas are exported.

MS Excel 97-2003 Workbook, values only

All formulas, whether or not supported by Excel, are replaced by the values which they return

Excel Workbook

This format has these properties:

Functions supported by Excel are exported as formulas
Functions which are not supported by Excel are replaced by their values
The content of hidden cells is visible if the cells are un-hidden in the exported file.
Cells outside the visible area are exported as hidden
Pictures are exported
Visible Area is exported
Print Area is exported
Color Palette is exported
Indentation in hyperblocks is exported
Cell comments are exported
Background image is exported

Excel Workbook, values only

This format has the same properties as the Excel workbook format except:

All formulas, whether or not supported by Excel, are replaced by the values which they return
The content of hidden cells is not visible if the cells are un-hidden in the exported file
Styles, conditional formats, column/row formats are applied. For example, if a cell has a conditional format and the condition is met, the format is applied to the cell in the exported file.

Functions which are not supported by Excel

If you export a report containing any of these functions to Excel Workbook or Excel Workbook values format, the functions will be replaced by the values which they return:


Application Studio Specific functions	Property functions	OLAP functions
SUMIF2	MERGEPROPERTIES	MEMBERGETMULTI
GROWTHX	GETKEYVALUES	CELLWRITE
GROWTHY	GETPROPERTYVALUES	NOTEGET
LINESTM	GETPROPERTY	CELLPROPERTYGET
LINESTB	GETKEYS	ROK
LINESTR	GETPROPERTIES	KEYGET
LOGESTB	SETPROPERTY	MEMBERCNAME
LOGESTR		RON
TRENDX		RWDB
TRENDY		CROSSLINK
		WBC
		RWA
		RDB
		HYPERLINK
		RWC
		CHECKSUM
		CELLPROPERTYGETMULTI
		GETTICKET
		NOTEWRITE
		CELLPROPERTYWRITE
		MEMBERGET
		HTML
		MEMBERNAME
		CELLGET
		RWN
		DBEXECUTE
		TRANSLATESTRING
		GETLEVEL
		ROA
		WBA
		HYPERBLOCK
		ROC

Other unsupported functions

Excel does not support graphics in number formats. When exported to Excel Workbook values format, the graphic is replaced by the value which it represents.

See graphics in number formats.

With some exceptions, Excel does not support number formats with more than three sections. The exceptions are number formats of four sections in which the fourth section is a string and does not have a condition. An example of an acceptable four-section format is an Accounting number format.

MS PowerPoint

In View mode, you can export a report to MS PowerPoint .pptx format.

HTML

By default, graphic objects, background images and charts are embedded in the exported html file. The file is exported to MIME format with a .mht file extension.

Optionally, you can:

Specify whether graphic objects, background images and charts are exported
Specify whether exported objects are embedded or exported to a sub-folder
Specify Plain html as the format. Objects are exported as images and the file is exported with the .html file extension.

Click Options in the Export Settings dialog box to open the Html Export Options dialog box.

Images

In View mode, you can export a report as a .PNG or .JPG image. The image is exported in a .zip file.

Export Reports (.reports)

You can export a single report or all the reports in a folder.

You can also export report books, scheduled tasks and custom hierarchies.

Report Definition (XML)

The option is available only for single reports. It is not available through the Export Wizard.

See Exporting to xml.

We recommend that, when you design a report which might be exported from Application Studio WebServices, you define an Export Report action in a cell. But you can also export reports with an HTML formula. For example:

=HTML("<a
                              				href='javascript:parent.topFrame.exportToExcel()'>Export to
                              				Excel</a>")

The formula displays a hyperlink in the report. Click the hyperlink to export the report to Excel.