Queries/Reporting

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

Adding a filtering field for Admins and Managers on 'Date Last Opened' alongside the existing Name, Description and Category will allow for easy tidying up of unused Queries.

I often have queries that I need to write, especially for Ripples, where I don't have the flexibility I need in the query builder. I need an IS NOT option i.e. the date was not yesterday or today, and I need a weekend option i.e. the date was not ...

You cannot currently build a query that shows if an assignment is part of an approved timesheet. We currently have staff that do assignments but dont send them for approval. The timesheet and assignment can still be approved but when reporting the...

Access Workspace is built around their Access Data Engine (ADE) allowing you to build Analytics within workspace to combine data from multiple Access and 3rd Party applications and present this consolidated data to selected individuals. It seems t...

We would like reports run to include the line manager/direct report's ID/employee number as a field, as well as the colleagues ID/employee number. At the moment, for a number of reports that include the manager, we are adding this manually.

This would be a great benefit to my managers who at the moment are having to work from two separate reports - Using the time sheet report to view and accept late/doctors etc, but then have to move over to the spreadsheet report and open People HR ...

Please could there be an option created to only bring back the most recent record on a logbook query. This would make it so much easier to report on something like someones pension record in the logbook section, only bringing back the most recent ...

For example being able to pull a Length of service report for how many teams will be over 2 years service at a specific date in the future

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