Issue:
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.

Resolution:
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.