When a report is generated, you can open the report in Report Viewer, as a Microsoft Excel worksheet, or as an XPS document.

The following sections provide additional information about the options for viewing a report:

Report options

Report options are defined in the Output and Distributiontab of a report definition. For more information about generating reports, see Generate a report .

General report options

The following table describes options that are available for all report output types.

Option

Description

Include headers and footers

Inserts the header and footer information that you configure on the Headers and Footerstab of a report definition.

Include format rows

Inserts the row definition rows ( DES, LFT, RGT, and CENrows) in the report. If a row is blank, it is considered a format row and will not be printed, unless Include format rowsis selected. By default, this option is selected.

Note Note

When this option is selected and the Include underscore rowsoption is also selected, the printed report might display duplicate underscores under the final total rows.

Include underscore rows

Inserts underscore rows and double underscore rows in the report.

Report duplicate accounts or dimensions

Generates an exception report that shows the financial data accounts that are duplicates.

Microsoft Excel options

The Microsoft Exceloutput type opens a report as an Excel spreadsheet. To view reports in Microsoft Excel, you must have Microsoft Excel 2007 or newer installed on your computer. For more information, see Excel and Management Reporter .

The following table describes the options that are available for reports that are opened in Microsoft Excelformat.

Option

Description

Include fonts and shading

Formats the report by using the fonts and shading that you used in the report building blocks and in the report definition on the Headers and Footerstab. For example, if you added shading or font colours to heading text, this option includes that formatting in the Excel spreadsheet.

Generate to a single worksheet

Generates the whole report, which includes reporting trees and drill down reports, to a single worksheet.

Include comments

Generates the whole report and includes any comments that are attached to the report.

XPS options

The XPSoutput type opens a report in a read-only format. To view a report in XPS, you must have the Microsoft XPS Viewer installed. For more information, see XPS and Management Reporter .

The following table describes the options that are available for reports that are opened in XPSformat.

Options

Description

Include bookmarks

For every unit of the associated tree that is included in the XPS file, a bookmark will be defined in the XPS file.

Include column and page breaks

Inserts column breaks and page breaks into the report.

Include comments

Generates the whole report and includes any comments that are attached to the report.

Column width

Specifies the width of the column, in characters.

Wrap text

If the text in a column exceeds the number of characters specified in the column width, this options wraps the text to keep all of the text in the column.

If the Autofitoption is selected, this option is not available.

Autofit

Automatically adjusts the width of the columns to fit the cell content.

See Also