Cross tab display issue

[sspk]

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

[kattaviz]

Hi,

Try converting the values which dont have data to Zeros.

[the_xxx]

Hi you can use place holder like replace null with any value you need. You can use COALESCE ([data item],'') function to achieve this.

[mvjcognos]

not only colesce use can also go for nvl(dataitem,' ')