Supressing '0' in cognos viewer

[babu babu]

Hi All,
Is there any possibility to supress '0' in cognos viewer when we run the report in HTML format.

Thanks & Regards,
Babu.

[Sreeni P]

U can't do it on cognos viewer,neither in report, check this with ur model, or else prepare one condition in the report , in condition check the value that is getting from the model, and hard code it with ur value.

[CognosPaul]

You should be able to do this. Under Properties -> Data Format, for any numeric or date format, there is a setting called "Zero Value Characters". If the value of that field is 0 it will replace it with what you put in. There is also a "Missing Value Characters" to replace null data.

[jahnavi]

As I know you cant do it in cognos viewer. You can acheive this by adding filter the queries