Hiding columns on a report? 1

[StuckInTheMiddle]

I have a report with several columns each followed by a running sum total. Nice and easy, however is there a way to 'hide' columns which have a running sum of 0? In others words all rows in that column where 0 so the running sum was 0?

Thanks

 

[mdthornton]

Set your row and sum control formats to something like:

#,##0.00;(#,##0.00);""

The significant part here is the 3rd section which is the format for zero amounts, ie blank.

Best Regards,
Mike

 

[StuckInTheMiddle]

Thanks Mike, that did the trick nicely!