Remove duplicates and suppress blank rows in crosstab

[ssudha]

Hi All,

I have a crosstab report that has two columns A and B. I want A to be displayed only once. So I remove duplicates. But a blank column is displayed. How can I suppress this blank column?

Thanks,
Sudhakar

 

[Sridharan]

What exactly you do when you say remove duplicates??? Also a look of your data and what you are after will help us to give you more accurate suggestions...

Sri

 

[ssudha]

How can we hide or suppress blank rows or blocks based on a formula?

Thanks,
Sudhakar