TM1 Forum

Dear all,

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

Thanks,

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.)

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

Charles Ang wrote: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.