Conditional Formatting

The Report Viewer allows you to format column headings and fields, to highlight data that meets specific criteria. For instance, if you want to call out fields for store sales above $100,000, you can do so by applying text and background formatting to those stores that meet those numbers.

However, it is a slightly more complex process than applying formatting options to entire columns. This section describes those complexities, including:

• Condition hierarchy
• Condition button states
• Applying conditional formatting

Condition Hierarchy

 If you have multiple conditions applied to a single field, their order will affect how they function. Conditions are read and applied from bottom to top, and the topmost condition overrides the one(s) below.

For example, imagine you have more than one condition applied to the same format element: red text for all stores over 20,000 square feet, and blue text for all stores over 30,000 square feet.

Condition Button States

Because conditions higher up in the hierarchy can affect those below, the font style selection buttons each have three states:

• Unchanged, which means it inherits the previous condition-based style, if any.
• Set, which means the style is applied to text that meets the condition.
• Not Set, which means the style is not applied to the text that meets the condition, and is removed if a conflicting condition lower in the conditional formatting hierarchy has marked that style as "Set".

By default, the buttons are in the "Unchanged" state. Clicking the buttons toggles you through the three states.

Style Button States

The background and font color pickers have buttons for similar states, but these states behave slightly differently:

• Unchanged, which means the field inherits the previous condition-based color, if any.
• Set, which means the color is applied to text or background of the field that meets the condition.
• No Fill (background only), which means no color is applied to the background that meets the condition. Regardless of conditions lower in the hierarchy, the background inherits the table's default color.

Both have two buttons at the top of the window, along with the color selection boxes.

You control these states through the background color picker and the font color picker windows, using the following buttons:

• No Fill (background only), which applies the No Fill state described above.
• Reset, which returns the text or background to the Unchanged state.
• The color selection boxes, which apply the Set state.
  
  

Color Picker Button States