Report Generation
LeaveWizard includes comprehensive report generation capability and provides two different basic leave reports that Managers can generate from within the application. This is in addition to a Monthly Allowance report email which can be generated and automatically sent to users which is covered in a separate Monthly Allowance report article. The reports pages are accessible from the ‘Leave’ drop down section of the main menu.
Leave & Absence
The Leave and Absence Report provides a list of requests which can be filtered by Work group, Employee, Event Type, Start Date and End Date. You can also choose to optionally include ex-employees in the report by ticking the ‘Include Ex-Employees’ box.
The results list is paginated and the page size can be selected. Initially the list is sorted by ‘Name’, the first column of the list, in ascending order. You can however sort by any column (Start Date, End Date, Duration, Creation Date or Status) by clicking the column title. Clicking the same column again will alternate between ascending and descending order. For example, clicking ‘Start Date’ will sort the previous list as follows:
There is also a range of buttons available on the page sub menu to allow easy access to common functions such as requesting leave, absence and overtime. The ‘Export to Excel(csv)’ button allows the generated list to be exported as a CSV (Comma Separated Value) file which can be read by Excel and other applications.
Remaining Allowances
The Remaining Allowances Report provides a list of users and their allowance information which can be filtered by Work group, Employee, Event Type and Year. The ‘Export to Excel(csv)’ button allows the generated list to be exported as a CSV (Comma Separated Value) file which can be read by Excel and other applications.
In addition to getting the remaining allowance report it is also possible to generate a time worked report for a user for the previous month from this page. On the far right hand side of each row in the list of users is a time worked export icon. Clicking this will export a time worked report as a CSV file. For example, clicking the icon for a user will create and download a CSV file which can be viewed using Excel as shown.
As you can see, the user’s work pattern and leave information is used to create a report showing the hours worked by them for the previous month. In this case, they have only taken 1 day as holiday in the month.