Suppress Zero in Customize Perspective Reports

[Charles Ang]

Dear all,

I have do customize report in perspective.
If there anyway to suppress zero rows that not in active form?

Thanks,

[declanr]

Nothing "out of the box".

You could write some simple vba that cycles across each cell in your row (1 row at a time) and hides the row if any of the cells contain a value.
Throw a macro button in above your report and you have a suppress zeroes button (you could have the first step of it looking at a hidden flag cell that it puts a 1 into if the last action was to suppress, then if you run it and its already a 1 it instead unhides all the rows and sticks a 0 back in the flag cell.)

[Charles Ang]

That means there is no other way beside writing a macro for it.
Thanks,

[declanr]

That means there is no other way beside writing a macro for it.
Thanks,

Not necessarily "no way"... the most obvious way that I ignored due to the fact your original post suggested you had already considered it; would be to just use an active form, that comes with a handy suppress zeroes button which changes the flag in the TM1RptView formula between 0 and 1, if you wish to use the form through tm1 web you can use a drop down to change that flag manually as well.