Print Page - hiding empty cell in crosstab

Title: hiding empty cell in crosstab
Post by: barrysaab on 18 Feb 2011 11:23:48 AM

I have crosstab report with some empty cells.I want to replace these empty cells with zero.could someone please suggest how could i do it.thanks

Title: Re: hiding empty cell in crosstab
Post by: rockytopmark on 18 Feb 2011 12:29:30 PM

Empty Cells in crosstabs happen when there isn't fact data at that intersection, otherwise known as a tuple.

This is easily rectified by changing the Data Format property of the Crosstab Intersection (Measure) in the Crosstab. Open the Data Format dialog, select Number (or Currency or whatever is appropriate), the scroll down until locate the "Missing Value Characters" property and simply enter 0 in there and hit OK.

HTH.... M

Title: Re: hiding empty cell in crosstab
Post by: barrysaab on 19 Feb 2011 12:30:33 AM

Thanks,rockytopmark.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: barrysaab on 18 Feb 2011 11:23:48 AM