Formatting Reports

You can configure the design of your report using a range of formatting options.

These options can be applied from individual report configuration tabs, or from the report layout after you have specified your configuration options.

Configuration Tab Formatting

Formatting toolbars are available in the following tabs:

  • Lens Configuration
  • Subtotal Columns
  • Table Configuration
  • Measure Columns

These formatting options, when applied to sections and row formulas, control the appearance of the data displayed in each row. To enable formatting, click each row and apply your required formatting with the formatting toolbar. You can click on a row to see any formatting applied to it.

Formatting Toolbar

The following formatting options are available from the formatting toolbar, depending on the tab in which it is displayed.

Formatting Options

Option

Description

Defines the font face for the text in your selected row.
Defines the font size for the text in your selected row.
Applies or removes bold formatting to the text in your selected row.
Applies or removes italic formatting to the text in your selected row.
Defines the text color in your selected row.
Defines the background color for the text in your selected row.
Defines the spacing between lines of text in your selected row.
Defines the horizontal alignment of text in your selected row.
Applies or removes underlining to the text in your selected row, and defines the underline color. This option is available for Measure columns only.
Applies or removes overlining to the text in your selected row, and defines the overline color. This option is available for Measure columns only.
Repeats the label for a selected grouping in your report. For example, a report might contain the following groupings:
Sales RevenueMaintenance
Product

Services

If you repeat the label for the grouping "Sales Revenue" in your report, it displays accordingly:

Sales RevenueMaintenance
Sales RevenueProduct
Sales RevenueServices
When selected for text font or size, returns the font to the default of Arial, and the size to the default of ten. This option is available in the Measure Column and Subtotal tab toolbars.

Clear any color selections specified for text background color.

Report Layout Formatting

You can use the following formatting options to change the appearance of your report after you have configured it. Right-click a column in your report to display the available format options.

Report Layout Formatting Options

Option

Description

Displays a list of all the columns added to your report.
Moves your selected column one column left.
Moves your selected column one column right.
Hides your selected column from display.
Saves changes applied to the presentation of your report layout.