Supress Zeroes on Active Form Columns

[bjones]

I've been trying to figure this out but don't see what i'm missing... in explorer i can easily supress zeroes and it get rid of any rows or columns that have all zeroes.
When i take the same view in Active form and try to supress zeroes it only supresses the row and the columns stay there full of zeroes. Is there a way to supress zeroes on columns in active forms?

Thanks

[Wim Gielis]

Hello

In active forms, rows are dynamic but columns are not.
So you will not easily achieve the same effect as the cubeviewer.

Wim

[declanr]

Sadly active forms don't support column suppression.
If you want to use an active form in the web then you are pretty much out of luck (unless you want to use some thoughtful conditional formatting and dynamic column name selection.)
If you are doing it through excel then VBA will get you there.

Wim beat me to it but I had typed this out so you still get it - feel free to ignore.

[bjones]

That's what i was suspecting. Thanks for your input guys