Within the Natural HR Report builder, there are a number of pre-built standard reports, including the option to run a Timeoff range report (Standard) which will allow you to view all time off within a particular date range. These reports can be shared with other access level users, click here to read the article on sharing Standard reports.
To access the Timeoff range report (Standard), you will need to go to:
Reporting > Report builder
Searching for 'standard' reports, you will see the 'Timeoff range report (Standard)' listed.
Click on the 'Edit' action to add or change the date range in the report
You can customise this report to better suit your business needs by:
- Changing the report name
- Add or remove any fields as required
- Edit field names or rearrange the order they will appear on your report
- Select a Group by field if required
- Add your own start and end dates for the range you want to report on
- Click 'Edit report' followed by 'View Report'
Each of the lines in the table will represent a single date where an employee has time off entered between the date range. If a request spans across multiple different days, each of these days will show as an individual line in the report.
Filtering the Time off range report
Use the 'Request ID' to group and identify those lines which are linked to the same request.
The report is now grouped by the 'Request ID'
but the Date column could be improved by sorting the date. Here we have selected
as one of our 'Select order by fields'
Using filters, the report can be manipulated further.
For example, we can add another filter by clicking on the '+'
We can change the start and end dates and then add a filter, in this case we will add:
Sickness, Cold/Flu, Doctor/Hospital Appointment
The report will now show only instances of Sickness, Cold/Flu, Doctor/Hospital Appointment between the chosen date range.
Click here to view our time off range report video.