Adding conditional formats to fields

You can add some conditional formats to a field, which refer to the DBField, parameter field, formula field, summary field, and the special field Page Number or User Name, then when the specified condition is fulfilled, the defined format will be applied to the field values for highlighting.

To add conditional formats to a field,

1. Right-click the field and select Conditional Formatting from the shortcut menu to access the Conditional Formatting dialog. See the dialog.

   

2. Click the button to open the Edit Conditions dialog to define the condition as required. See the dialog.

   

   There are the basic and advanced modes of the dialog for you to define either simple or complex condition expressions. See Applying filters to business/report cubes for details about how to define a condition.

3. When done, click OK to save the condition.

   The newly added condition will then be 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, etc.
5. Repeat the above steps to add more conditions and define the format for each condition as required.

   To edit a condition, select the condition in the Condition box, then click . In the Edit Conditions dialog, edit the condition 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.

See also Conditional Formatting dialog and Edit Conditions dialog for details about options in the dialogs.