Report style

You can define how your report is displayed using the options on the Report Style tab.

To use Microsoft Excel cell formatting, clear Apply Auto Format.

Create Excel Table

You can output your report in Microsoft Excel table formatting by selecting Create Excel Table. Preview the format of your selection in the Preview window.

Apply auto format

You can apply a predefined format to your report by selecting Apply Auto Format and selecting an option from the drop-down menu. Preview the format of your selection in the Preview window.

Each predefined report style uses up to six types of formatting which specify the appearance of reports to which they are applied., but you do not need to apply all of them. Clear the formats you do not wish to apply to your selected report style:

Number.
Pattern.
Font.
Width.
Alignment.
Border.

Note: Clear the Width option to disable column auto-resizing during recalculation.

Output table names

The names of the tables from which the information is extracted, are displayed as report headers. The default is not to output table names.

Output data item names

The names of the output items specified in the query, are displayed by default.

Totals

Display the sum of a numeric output item. Totals are displayed by default.