Skip to main content

Adding Conditional Formats to Data Fields

  • Updated

BackPrevious TopicNext TopicNext

Adding Conditional Formats to Data Fields

You can add conditional formats to the data fields in tables, banded objects and crosstabs in a report, then when a specified condition is fulfilled, the format defined on the condition will be applied to the field values automatically. This is very useful to highlight values that might need to be acted.

To add conditional formats to a data field:

  1. Right-click the data field and select Conditional Formatting from the shortcut menu. The Conditional Formatting dialog appears.

    Conditional Formatting dialog

  2. Select the button Add button to open the Edit Conditions dialog to define a condition.

    Edit Conditions dialog - Basic mode

    There are the basic and advanced modes of the dialog for you to define either simple expressions or complex expressions. See Applying a Filter to the Business View for a Data Componentfor more information on how to define a condition.

    When you are adding conditional format to a data field in a crosstab, you can find the button Formula button next to the value text box of a condition line. Select the button and you can select a dynamic resource or an aggregation object from the drop-down list to use its value in the condition. The listed resources are of the same data type as the field on which the condition is based.

  3. Select OK to save the condition.

    The newly added condition is now displayed and highlighted in the Condition box in the Conditional Formatting dialog.

  4. In the Format box, set the format which will be applied to values of the field when the specified condition is fulfilled, for example, the font face, font size, font color, and so on. Check Blinking Text if you want to make the values blink, then in the Duration text box, set how long it takes the values to complete the transition from the foreground color to the transparent color, in seconds. The blink settings work in the HTML result of the report too.
  5. Repeat the above steps to add more conditions and define the format for each condition.

    To edit a condition, select the condition in the Condition box, then select Edit button. In the Edit Conditions dialog, edit the expressions as required.

    To remove a condition and the corresponding format, select the condition in the Condition box and select Delete button.

    To adjust the priority of a condition, select the condition in the Condition box and then select Move Up button or Move Down button.

  6. Select OK to apply the conditional formats to the field.

Note: To make the blink settings of a conditional format take effect, you need to make sure the web browser you use supports CSS3 animation, such as Firefox, Safari, Chrome and Internet Explorer 10 or above.

BackPrevious TopicNext TopicNext