How to suppress zeros in COGNOS 8 Report Studio ?

Hello,

Suppressing zeros in the report is another commonly faced problem. If you are working on a Cross Tab then just add a filter to it with
CASE WHEN ( )
THEN (NULL)
ELSE ()

or

IF THEN ELSE

I hope they work for you.

Sandeep

Intro to the Blog and Cognos

Hello Everyone,

I have planned to maintain this blog to write some of the issues / solutions that I come across while working with cognos.

I am a Cognos Consultant and have been working with it for sometime now. Basically let me give in some details on what is Cognos and what it does. Here we go.....

Cognos is the world leader in business intelligence (BI) and performance management solutions. They provide world-class enterprise BI, planning and consolidation software and services to help companies plan, understand and manage financial and operational performance.
T hey bring together technology, analytical applications, best practices, and a broad network of partners to give our customers a complete performance solution. They provide an open and adaptive solution that leverages an organization's ERP, packaged applications, and database investments.

Cognos serves more than 23,000 customers in more than 135 countries. Their solutions and services are also available from more than 3,000 worldwide partners and resellers.
(courtesy: www.cognos.com)