Hi All,
Is there any possibility to supress '0' in cognos viewer when we run the report in HTML format.
Thanks & Regards,
Babu.
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.
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.
As I know you cant do it in cognos viewer. You can acheive this by adding filter the queries