Hide empty column in crosstab

sarika.np

I?m building a report using cross tab. In the report a status column is taken as group header. Now, when this dimension is empty/null then an empty column is coming as I have created grouped on this. I want to hide this empty column. Please refer the pdf attachment

Any idea how to remove the empty columns?

Regards,
Sarika

A@vi

Sarika.....

I guess...
Go to the report design in crosstab column.
Write click on that "Show/Hide Measures" & unclick the selection which column u dont want.
Hope this will Solve your problem...

Thanks
Avinash