How to Suppress ‘Zero’ values in a report in a Web TimeSheet report?

Find resources designed to help you get the most from Replicon

When running a report, the user hours for certain tasks entered shows 0 because 0 hours were entered against it. You might not want to see the zero value in the Web TimeSheet report.

The zero values cannot be hidden in the report generated by the application.

However, the report can be exported to Excel and the 0 values can be suppressed by executing a code.
Once the report is exported to Excel please follow the steps given below:
  • Select the worksheet in which the user wants to hide the column which has 0 values.
  • Right click on the worksheet and choose View Code to open the Visual Basic Editor.
  • Then choose Edit.
  • Paste the following code given below:

    • Sub Hide_rows()
    • Dim LastRow As Long
    • Dim Rng As Range
    • Dim Sht As Worksheet
    • Dim allwShts As Sheets
    • Set allwShts = Worksheets
    • Dim Asht As Worksheet
    • Set Asht = ActiveSheet
    • Application.ScreenUpdating = False
    • For Each Sht In allwShts
    • For i = 1 To allwShts.Count
    • Sheets(i).Select
    • LastRow = Sheets(i).Range("A65536").End(xlUp).Row ' << Change Col A to your Col
    • Set Rng = Sheets(i).Range("A1:A" & LastRow) ' << Change Col A to your col
    • For Each cell In Rng
    • If cell.Value = "0" Then
    • cell.EntireRow.Hidden = True
    • End If
    • Next cell
    • Next i
    • Next Sht
    • Asht.Select
    • Application.ScreenUpdating = True
    • End Sub
Close the Visual Basic Editor window and any column which has 0 value would be automatically suppressed.


Start a free Replicon trial today based on your business needs

Start Free Trial