How to apply simple conditional formatting in Report Studio?

 Technote (troubleshooting)
 
Problem(Abstract)
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.

 
Related information
Report Studio Users Guide
 
 
Cross Reference information
Segment Product Component Platform Version Edition
Business Intelligence & Financial Performance Management Cognos 8 Business Intelligence Cognos Connection
Business Intelligence & Financial Performance Management Cognos 8 Business Intelligence Query Studio
Business Intelligence & Financial Performance Management Cognos 8 Business Intelligence Report Studio
Business Intelligence & Financial Performance Management Cognos 8 Business Intelligence Transformer
Business Intelligence & Financial Performance Management Cognos ReportNet ReportNet
 
Historical Number
1018262
 
 

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Cognos 8 Business Intelligence
Analysis Studio

Software version:

1.1, 7.4, 8.1, 8.2

Operating system(s):

AIX, Linux, Solaris, Windows

Reference #:

1339405

Modified date:

2010-12-13

Translate my page

Machine Translation

Content navigation