If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Converting 00:00(HH:MM) to Blank

Started by Good Friend, 09 Sep 2015 11:29:30 PM

Previous topic - Next topic

Good Friend

Hello All.

I have a requirement where i need to show blank in the report output whenever we have 00:00(HH:MM) data. I have used Interval Range conditional style and put threshold interval as 0, but its somewhere breaking and not showing the exact result. I even tried to show zero value characters as blank using data format option, but i was unable to remove the colon. When it comes to casting the data item, it was initially casted to interval second from integer and then using data format "time interval" property, HH:MM are being displayed. So again casting the data item doesn't seem to be working for me.

Is there anyway to show report output as blank whenever we have 00:00 in the output using conditional style preferably. Please advise.