Previous Page Next Page

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.

   

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

   

   There are the basic and advanced modes of the dialog for you to define either simple or complex condition expressions. Click here for more information on how to define a condition.

3. Click 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 click . 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 click .

   To adjust the priority of a condition, select the condition in the Condition box and then click or .

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

Previous Page Next Page