BackPrevious Topic  Next TopicNext

Adding Conditional Formats to Fields in Page Report

This topic describes how you can add conditional formats to a data field in a page report, to highlight values that you want to view and act on. Then, when the specified condition is fulfilled, the format that you defined on the condition will apply to the field values automatically.

To add conditional formats to a field:

  1. Right-click the field and select Conditional Formatting from the shortcut menu. Server displays the Conditional Formatting dialog box.

    Conditional Formatting dialog

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

    Edit Conditions dialog - Basic mode

    You can use the basic or advanced mode of the dialog box to define either simple or complex condition expressions. See Applying a Filter to the Business View for a Data Component for 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 Toggle to Formula button Formula button next to the value text box of a condition line. Select the button and you can select a field from the list to use its value in the condition. Server displays these types of fields in the list, which are of the same data type as the field on which the condition is based.

    • Crosstab formulas if the crosstab uses a query resource.
    • Dynamic resources and aggregation objects if the crosstab uses a business view.
  3. Select OK to save the condition.

    Server displays and highlights the new condition in the Condition box in the Conditional Formatting dialog box.

  4. In the Format box, set the text format you want to apply to the values of the field when the specified condition is fulfilled, such as font face, font size, and font color. 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 output too.
  5. Repeat the preceding steps to add more conditions and define the format for each condition.
  6. To edit a condition, select the condition in the Condition box, and select the Edit button Edit button. Then, in the Edit Conditions dialog box, edit the condition expressions as required.
  7. To remove a condition and the corresponding format, select the condition in the Condition box and select the Remove button Delete button.
  8. To adjust the priority of a condition, select the condition in the Condition box, and then select the Move Up button Move Up button or Move Down button Move Down button.
  9. Select OK to apply the conditional formats to the field.

Note iconTo 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.

Back to top

BackPrevious Topic  Next TopicNext