TM1 Forum • Zero Suppress on Pages for Excel Report Printing

Page 1 of 1

Zero Suppress on Pages for Excel Report Printing

Posted: Thu Aug 19, 2010 9:59 am

by mce

Hi,
When using print report feature in Perspectives, is it possible to suppress zero pages while generating/printing multiple sheet reports?
Regards,

Re: Zero Suppress on Pages for Excel Report Printing

Posted: Thu Nov 06, 2014 11:31 pm

by Shelly

Was a solution to this ever found? I have the same need.
Thanks

Re: Zero Suppress on Pages for Excel Report Printing

Posted: Thu Nov 06, 2014 11:44 pm

by declanr

Just make the subset in the relevant SUBNM formula an MDX expression filtered on whether there are values found in the intersection being printed.