Skip to end of metadata
Go to start of metadata

Conditional formatting is the capability to change the appearance of report component depending on certain conditions. ClientUI Reporting supports several conditional formatting which can be used in a report document. To give an in-depth explanation, this topics is divided into the following sections.

On this page:

Using Format Condition

Format Condition allows you to easily define the formatting for reporting components such as TextBlock depending on certain conditions of the current value. Note that, only several properties can be changed through format condition, such as Background, Border, Enabled, FontFamily, FontSize, FontStretch, FontStyle, Foreground, FontWeight, Margin, StyleName, TextAlignment, and Underline.

You can easily defines it using the condition editor, which can be accessed from the ribbon. See the following illustration.

Using Data Bar Condition

Data Bar Condition allows you to easily visualize the percentage values of data fields using a data bar. Note that, it only can be applied on TextBlock components. In general, the condition works according to the following principle. All the values in a specific data column are analyzed to determine the maximum and minimum values. Minimum value corresponds to 0 percent, and maximum value corresponds to 100 percent. You may also define the minimum and maximum value. When rendering each report component, to which the condition is applied, the percentage of value in current data column is calculated from the minimum and maximum range. Data bar is rendered depending on the percentage value. The closest the calculated value to it's maximum, the greater length the data bar would be. The data bar will be almost unfilled if the calculated value is close to or equal to a minimum value.

You can easily defines it using the condition editor, which can be accessed from the ribbon. See the following illustration.

Using Color Scale Condition

Color Scale Condition allows you to easily visualize the percentage values of data fields using a color scale. Note that, it only can be applied on TextBlock components. In general, the condition works according to the following principle. All the values in a specific data column are analyzed to determine the minimum, medium, and maximum values. If the color scale consists of 2 colors, then the color will be an interpolated color of minimum and maximum value. If the color scale consists of 3 colors, then the color will be a smooth transition between the three colors. If the value is between the minimum and average value, then the color will be an interpolated color of minimum and medium color. The color will be an interpolated color of minimum and medium color if the value of current data column is between the minimum and average value. The color will be an interpolated color of medium and maximum color if the value of current data column is between the average and maximum value.

You can easily defines it using the condition editor, which can be accessed from the ribbon. See the following illustration.

Using Icon Set Condition

Icon Set Condition allows you to easily visualize the values of data fields using an icon depending on the defined value range. Note that, it only can be applied on TextBlock components.

You can easily defines it using the condition editor, which can be accessed from the ribbon. See the following illustration.