In Accpac there was a ".Z {R}" command "The Suppress Zero Lines specification prevents lines containing zero figures (except totals) from being printed".

Q: Is there an equivalent command in the Adagio Reporter and NO, I don't want to use Smartsheets.

There is very useful for management reports that have different active/used accounts across various departments and still be able to use the same report both separate and consolidated.