When printing statements from the Financial Reporter I would like zeroes displayed as hyphens instead of as zeroes. I can do this using an If statement, but in doing so I cause the Zero Suppress function to no longer work as the rows are no longer all zero. I have tested all of the built in formats but none provide the feature.

Excel offers this function as part of the "Accounting" Format. Is it possible to do the same thing in Adagio's Financial Reporter?

Hi Phil,

So you want Zero Suppress to suppress values other than zero? That in addition to having options to automatically print values other than 0.00 for zero balances (other than blank)? I can forward these suggestions to development. Though there inevitably will be some features in Excel that can't be replicated in the Financial Reporter (ie. how to you zero suppress rows in Excel?).

If having the hyphens in the Financial Reporter is important, then using the IF statement is the way to do it. You could use the ADSELECT function to select records (instead of using Zero Suppress); the syntax for this is:
ADSELECT("record range","criteria")
There are a few examples in the Help file, in the 'Adagio' functions list. Here's one:
ADSELECT("1000:9999","{BAL} <> 0")

Remember you can export financial statements to Excel - and can apply the hyphen formatting there if necessary.

Hi Phil M,

We have had this request several times, but it is difficult to change the available formatting options as these are buried deep within the code of the financial reporter. It is on our list of things to "look at" though.

Also, you can use ".RowFormat" and the Style "FormatHidden", as an alternative to suppressing zero balance rows.