Currently the only way to hide zero rows in Sage Intelligence is to set a macro for every workbook and column that you want to set as a zero row. This can be a problem as there can be potentially hundreds of columns and workbooks and potential for getting errors if the workbook or column isn't exactly right. Prior to v2015 there was the option to run the hide zero rows within the report but that functionality has been removed.

Please add a way to either hide the zero rows on the fly on the report or a utility that can check each zeroingll macro for errors so one does not have to go through potentially hundreds of macros.

by: Richard S. | over a year ago | Reports / BI