hiding empty cell in crosstab

[barrysaab]

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

[rockytopmark]

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

[barrysaab]

Thanks,rockytopmark.