COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: cogminator on 19 Sep 2005 09:15:16 AM

Title: Blank columns in a list in report Studio
Post by: cogminator on 19 Sep 2005 09:15:16 AM
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 ?
Title: Re: Blank columns in a list in report Studio
Post by: cognosfreelancer on 19 Sep 2005 10:04:24 AM
can you paste the report spec

NKT
Title: Re: Blank columns in a list in report Studio
Post by: sir_jeroen on 19 Sep 2005 11:18:37 AM
Have you tried adding a blank textbox / block?
Title: Re: Blank columns in a list in report Studio
Post by: mallika on 28 Sep 2005 01:16:40 PM
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.