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

Blank columns in a list in report Studio

Started by cogminator, 19 Sep 2005 09:15:16 AM

Previous topic - Next topic

cogminator

I want to display a list with a column by day for a specific value.
The problem is if no value exists for one day, I want to display an empty column wih just the title (day number x).
if no value exists, no column is displayed.
Who can help me please ?

cognosfreelancer


sir_jeroen

Have you tried adding a blank textbox / block?

mallika

try changing the data format properties for that column. Set the 'missing value character' to some value, so that the column does not disappear when data is missing. Finally if you want to not display that value, try and apply conditional format on that column using the 'is missing', 'is null' or 'is not missing' functions. I have not tried this but thought it might work.