Conditional Formatting of Crosstab Cells for Studio Reports

Applies to: Kyvos Reporting

Conditional formatting in Kyvos Reporting allows you to dynamically apply visual formatting to Crosstab cells based on specific data values at runtime. This helps highlight important trends or anomalies directly within the report.

Examples:

• Highlight sales values in red when they fall below the target.

• Show a value in bold if it's 20% higher than the same period last year.

• Apply background color changes to indicate thresholds in flight occupancy or employee attendance.

When to Use

Use conditional formatting when you want to convey additional insights without adding extra fields. For example:

• Display expenditures in bold if they exceed a defined limit.

• Highlight underperforming sales with a red background.

• Color-code flight occupancy rates based on thresholds.

• Apply color schemes to staff presence data:

  • 100%: Blue text

  • 80%: Red text

  • Below 60%: Red background with yellow text

Preparation Steps

Before applying conditional formatting in a crosstab report, complete the following steps:

1. Define conditions
   Create logical expressions that evaluate the report data (e.g., Sales < Target).

2. Define styles
   Specify formatting elements such as text color, background color, font weight, or underline.

3. Map conditions to styles
   Link each condition to a corresponding style format.

Apply Conditional Formatting to Crosstab Cells.

Once conditions and styles are set up:

1. Open the Crosstab report in Kyvos Reporting Studio.

2. Right-click the target cell (row header, column header, or summary field).

3. Select Conditional Formatting from the context menu.

4. In the Conditional Formatting dialog:

   • Select the condition(s) to evaluate.

   • Choose the style(s) to apply when the condition is true.

5. Click OK to apply changes.

You can apply multiple conditions and styles to a single cell.