We had the same issue with suppressing zero rows once the report is run out and wanted to share our solution.
Background: The ZeroFill function is used to suppress rows which have zero value in a particular column in the Excel Workbook.
If a parameter…