TABLE OF CONTENTS
- Row Styles
- Striped Rows
- Expanded Rows and Stripes
- Row Styles and Stripes
- Measure Colors and Stripes
- Breadcrumbs as Title
Figure 1: General
Appearance settings are used to customize the look and feel of a finance report.
You can set the Default background to stripes or fixed (Figure 2) choose the Background color for the whole report, enable Expanded Background to set colors for odd and even rows and set the Link color. You can also choose a Header color and Header text color, choose to Display measures... above or below column dimensions, and use Hide headers to display and position headers.
Figure 2: Default Background, Background and Header
To configure your dimensions display, you can enable Show dimensions dropdown, choose to Use first dimension as title, enter Dimensions Dropdown label and use Breadcrumbs as title. You can also Use browser scrollbars, Hide row hover to deactivate hover animation and enable a Top dimension separator.
Column settings include setting a Min Column Width, choosing a Dimension column width from Default, Fixed or Relative (% of total width), and enabling Adjust headers width to adjust the header column width by Data or Text (Figure 3).
Figure 3: Dimensions and Column width
It's possible to style the rows from the property panel (Row Styles). By default, there are 4 styles but more (up to 99) can be added as needed. Every style has a number , eg. Regular (0), SubTotal(1). This number relates to the row style number in the excel file (see the section about the excel template)
The following options are available (Figure 4).
Figure 4: Row Styles
Stripes are enabled in the property panel under Default background (Figure 5), with a choice of Stripes (displays stripe settings, applies stripes to all rows, including expanded rows) or Fixed (no stripes or stripe settings displayed).
Figure 5: Default Background
Once activated, the user can change color for odd and even rows as well as the color of the text (Figure 6). Colors can be selected by either the color picker or as an expression that returns a color such as “=Green()“ or “=RGB(125,125,125) or even a hex color code.
Figure 6: Row Color
Expanded Rows and Stripes
Stripes in expanded rows can be turned off/on in Appearance using Expanded background settings. This allows striped normal rows and a fixed color on expanded rows, while different colors can be set for stripes to create a distinct pattern for expanded rows (Figure 7).
Figure 7: Expanded Rows
Row Styles and Stripes
There is a setting in Row Styles to choose between using the preset background or the striped background setting. By default a couple of Row Styles are already in place.
When enabling striped rows, the striped setting is applied to all Row Styles. This can be enabled or disabled by the user, and each Row Style color overrides the stripe colors when the color is set to fixed.
Measure Colors and Stripes
A color expression in Data / Measures will always override a stripe setting. e.g. the expression '=Red()' in the background color expression of a measure will be used regardless of any Striped settings.
Breadcrumbs as Title
Enabling Breadcrumbs as title will show the dimension names as the title for the first column. The name of each dimension will appear as they are expanded in the table (Figure 8).
Figure 8: Breadcrumbs as Title