How to Create Conditional Formatting in Cognos Report Studio | A Complete Guide

• In this article you will get
• 1.Why use Conditional formatting?
• 2.Conditional formatting
• 3.Conditional formatting – String variables
• 4.Conditional formatting – Boolean variables
• 5.Conclusion

Why use Conditional formatting?

Almost each object that can be used in report can have Conditional Formatting applied to it… the exceptions are some , with Singletons, Custom Controls not having feature. The most typical use for the Conditional Formatting is probably are Red/Yellow/Green formatting of values to an indicate bad/fair/good performance, but usefulness of a Conditional Formatting extends beyond this example.

Used Conditional Formatting most recently to hide a rows/columns of a Crosstab if a specific condition is met/not met, or similarly, to hide a prompt controls. Another good use is a styling within multi-dimensional authoring (such as TM1 cube) where multiple levels of hierarchy are being rendered.

Conditional formatting

Conditional Formatting is the process of formatting a business data based on given condition.Users can quickly analyse the business data by using a conditional formatting.Conditional formatting can be done with a help of the variables.There are three types of a variables – STRING, BOOLEAN, REPORT LANGUAGE VARIABLES.Variables are used to hold results of the expression.

Conditional formatting – String variables

Conditional formatting – Boolean variables

Conclusion

The user knows how to log in to the Cognos Analytics.The user has capabilities assignments necessary in a Cognos Analytics to use a report authoring.The user knows a name and location of package or data module that is available for them to the author and has adequate knowledge of this data source.