Conditional formatting in Designer

Use conditional formatting to control how values in the report table are displayed based on conditions of the data in the report.

Note: There is a known issue that prevents conditional formatting from working with Summary Bands. These are some prerequisuites for using conditional formatting on Summary and sub Summary Bands:
  • When applying conditional formatting to the summary and sub-summary bands, the conditional formatting expression must exactly match the column expression or measure used to create the band. While case differences are acceptable, the expression must not include any extra whitespace.
  • When using a ratio expression in the summary band, the conditional formatting expression should follow the format Numerator/Denominator, ensuring there is no space before or after the division operator.
  1. From the Designer report, select an entity.
  2. Select the Conditional Formatting icon.
  3. Select +Add Conditional Formatting.
  4. Select the entity.
  5. Provide an expression that returns a boolean value. The formatting is displayed if the BQL expression evaluates to true.
  6. To add another condition to the same entity, select the +Add Condition button.