Previous Topic  Next Topic

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. Report Server displays the Conditional Formatting dialog box.

   

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

   

   There are the basic and advanced modes of the dialog box 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 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 box.

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. Select 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 . In the Edit Conditions dialog box, edit the expressions as required.

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

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

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

Previous Topic  Next Topic