Queries/Reporting

I needed a list of employees based in each of our office locations as at a historic date. There's no way of doing this under the current query filter options so it would be great for this to be added.

I want to be able to run a query that shows the hours absent each day, not the total for the absence. As an example, if someone is absent from 10 to 14 February, I'd like to see a line of data with the number of hours for each day (Monday 10th - 7...

The finance team need to be able to print the expense sheet in PDF format for each employee's expenses from clicking the Approved button. Currently they cannot see the whole page unless you scroll down to see all the expense entries, so if you scr...

Managers receive email notification for time sheets and then approve and make comments. It would be really useful if we could report on comments made by managers re timesheets as currently no one can see it apart from admin or manager.

It would be cool if you could select a catergory of queries and then have a 'run all' button or if you were able to select a group of queries that you wanted to download at the same time. eg go into Staff List category, select all the queries in t...

In the planner, the field 'Was your sickness caused by an accident at work or an industrial disease' is a tick box. At the moment, this can't be reported upon in a query. This would be helpful because it would allow a query to easily and quickly s...

Add a new option to reports for the full name, to show the first and surnames in the same field. This will be auto populated from the existing first/surname fields, rather than a field that is manually entered for each employee. This will enable m...

I think it would be quite helpful (and relatively simple) to colour code each of the fields in the right hand pane of the query builder along with their corresponding section title in the left hand pane.

It would be useful if we could have the option to add multiple columns of the same area into a report, as currently this can only done via multiple reports. Further filters/drill downs into this would make reporting more insightful. For example: S...

For example, when pulling a report for this time last year, so see employees salary, department, role, work hours etc as what they were this time last year instead of pulling several reports.