Hiding Columns with no data

[tunjio]

I have got a requirement from my users that after refreshing a report if a particular column(s) has no data, they want this column hidden , i.e not to be displayed in the report. Can anyone suggest how this can be done please?

Thanks

 

[skrandel]

It really can't be done. The best you can do is to use Alerts to make it look like it was hidden (no border;white font). But it won't collapse the other columns in it's place.

You could get clever with blocks and overlay them so that it looks like what you want. But this will only be practical if you have small number(1 or 2) of "Variable" columns.

Steve Krandel
VERITAS Software

 

[nimmy99]

If you use the option Set as master (not on the column which you want to hide), it will automatically hide the empty colmn

 

[skrandel]

Huh?

That's only true with a crosstab.

Steve Krandel
VERITAS Software