From version 6.8.10 upwards, Jarrison Time is able to generate a daily totals report based on department or other employee field selections.
In this article we’ll look at how to setup a new daily totals report. This report will show NT hours broken down by the Class field: contractors, temp, and permanent staff. Overtime, or any other time categories (or counters) could be used. The example will first look at grouping only by Department, then include Site. Whichever employee field suits your needs would naturally need to be correctly populated and assigned in Jarrison Time.
Open the Report Creator (View > Report Creator). Click Add on the lower left to create a new report, and select Day Totals as the Report Type. You can add other report info as desired.
On the Details tab, date, department, and NT will be added. The time category or counter must be added as many times as there are reporting options, in this case there will be three lines of NT (permanent, contractor, temp).
Each NT line will be a trigger and have the Only If Condition applied, for our purposes if there is any amount of NT it will be sufficient as trigger. The Where Condition will also be selected appropriately, in this case Class is selected as that is what we want to split our reporting category by. The first NT line will provide Contractor time, hence they are selected.
The second NT line is the same as the first, but with the Class selection changed to Permanent, to report NT of Permanent employees.
The last line has Temp as the Class selection.
The Totals tab would only sort by Department.
Below is sample output of the above report setup:
Next we’ll add Site as a sorting level. First by adding it as a regular column on the Details tab, and then also as first sort option on the Totals tab in Report Creator.
The above changes result in output similar to below, reporting NT totals split by Class, sorted by Site then Department.
