COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sspk on 20 May 2010 03:23:48 PM

Title: Cross tab display issue
Post by: sspk on 20 May 2010 03:23:48 PM
Hi all,
I am using cross tab which has insurer code in column, revenue as the measure and LOB Type in the rows.
Now when i run the report the cross tab is hiding the column name that don't have any values in the cell.Is there any way to display those hidden column names even if they don't have values.Any suggestions please.

Thanks
Title: Re: Cross tab display issue
Post by: kattaviz on 21 May 2010 03:38:46 PM
Hi,

Try converting the values which dont have data to Zeros.
Title: Re: Cross tab display issue
Post by: the_xxx on 24 May 2010 01:21:47 PM
Hi you can use place holder like replace null with any value you need. You can use COALESCE ([data item],'') function to achieve this.
Title: Re: Cross tab display issue
Post by: mvjcognos on 14 Jul 2010 03:48:50 AM
not only colesce use can also go for nvl(dataitem,' ')