Vizlib Home Try Vizlib
Welcome
Login

Vizlib Finance Report Properties - Row Styles

Settings for Row Styles control the appearance of the rows in the report. By default, there are 4 styles but up to 99 can be added. Every style has a number, eg. Regular (0), SubTotal (1). This number relates to the row style number in the excel template file.  


TABLE OF CONTENTS


Row Styles


You can enter a Label, set a Text color, Background color, Border color, a Border Type, select an Indent and choose to Apply on expanded, set a Font Style and choose Hide Indicator


Figure 4: Row Styles


You can also enable a Separate Row Style for row totals (Figure 5) to display the row style settings and use them to customize total rows added by the dimension Show totals setting. 


Figure 5: Separate Row Style for Row Totals


Back to Contents


Striped Rows


Stripes are enabled in the property panel under Default background (Figure 6), 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 6: Default Background


Once activated, the user can change color for odd and even rows as well as the color of the text (Figure 7). 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 7: Row Color


Back to Contents


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 8).


Figure 8: Expanded Rows


Back to Contents


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.


Back to Contents


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.


Back to Contents


K
Kenneth is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.