Your source for IBM Cognos 8 and 10 support and tips.
Purchase your Section 508 Compliance Support guide now!
Purchase your Section 508 Compliance Support guide now!
How to apply simple conditional formatting in Report Studio?
How to apply simple conditional formatting of a report in Report Studio?
Resolving the problem
Highlight data in a report to better identify exceptional results. For example, to identify sales representatives who have exceeded their quota, create a condition that checks if each representative's sales for the year is greater than their quota for the year. Steps:1.Open the report that you want. 2.From the File menu, click Variables.
3.Create a variable by clicking the add button bellow the Variables box.
4.In the Name box, type a name for the variable.
5.In the Type box, select the type of variable you want to create:
To create a variable that has only two possible values, yes and no, click Boolean.
To create a variable whose values are string-based, click String.
6.Click OK.
7.Click the Edit button below the Expression box.
8.In the Expression Definition box, define the condition.
9.Click OK twice.
10.In the work area, click the column that you want to highlight based on the condition you just created.
11.Click the Condition Explorer button. The Condition Explorer dialog box appears.
12.Click the variable you just created.
13.In the Properties pane, click the Conditional Style property.
14.In the Variable dialog box, click the Variable box.
15.Click the variable you want to assign to the object.
16.In the Values box, select the values you want the condition to support.
Tip: A default value exists for each variable you define, and it is always selected.
17.Open the Condition Explorer dialog box again, and click one of the possible values for the variable other than the default value.
For example, if you created a boolean variable, click the Yes value.
18.In the Properties pane, specify the formatting that you want to highlight the column with when the condition is satisfied.
For example, click the Border property to create a thicker border around the column.
19.Repeat steps 17 to 18 for other possible values defined for the variable.
20.Repeat steps 10 to 19 for other objects that you want to highlight.
Tip: In the Condition Explorer dialog box, click (No variable) to view how the report looks when no variable is applied.
When you run the report, the report objects to which you applied the variable are highlighted when the condition is satisfied. For example, if you created a Boolean variable, the objects are highlighted when the condition is met.
