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 Revenue Maintenance Product Services If you repeat the label for the grouping "Sales Revenue" in your report, it displays accordingly: Sales Revenue Maintenance Sales Revenue Product Sales Revenue Services
	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.
	Adds a percentage symbol to indicate percentage values displayed in calculated rows in your reports.

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.
	Select either option to move your selected column one column left or right. You can also reposition your columns by dragging and dropping them to their required location in your report.
	Hides your selected column from display.
	Displays the selected lens's subtotal value on the report table.
	Saves changes applied to the presentation of your report layout.