How to Apply a Conditional Style to a Column
Conditional styles on columns apply to Report Table Views and Report Matrix Views.
This enables to apply a conditional style on a column.
To apply a conditional style to a column:
1. Access the Report Table Column (or Report Matrix Column ) properties.
*Access and expand the Report Table View or Report Matrix View concerned, see Accessing the Report Templates and their Constituents.
2. Display its Style page.
3. Click Add .
4. Enter a Name to your conditional style.
5. In the Style Parameters list, select the style you want to add on condition.
*Only the style parameters applying to the Report Data View renderer are listed. You can sort them according to a specific column (for example, according to the Applies to column) or use the list filtering tool to filter the styles.
*You can select several styles.
6. Click Next.
7. In the Style Parameters list, select the style parameter and configure it in the right part.
Example: for a Cell Background Color or a Series Color, in Value keep "Fixed" and select a color.
8. Click OK.
9. In the Style page, select your style row.
10. In This style applies on the following condition:
• in the Name field enter a name describing the condition
• in the pane enter the code for your condition.
*For code syntax, see Report Style Condition Properties.
Example:
For a column with numerical values, to add a condition style on values greater than 80000 enter:
[1:ConditionGroup]
1=value,&Current,>,80000