Queries/Reporting

We are looking to build a report that shows the individual hours per day we have some staff that do the same number of hours per week but on a different working pattern to the standard 40 hrs p/week / 8 hrs p/day. We need this for checking the cor...

It would be really great to be able to activate a ripple to go on a certain day of the month.

We have to manually check all Bradford Factor scores as People HR will only add in a sickness absence to the Bradford factor score if an employee has not other event on the same day. (i.e. if an employee booked a morning off as sick, was due to wo...

Our accountants often request a tally of who has what holidays outstanding at the end of a period and there is no report to calculate this. I therefore have to spend hours manually looking at this.

Have the ability (like is already in place in most systems) to schedule reports to send out to managers/generic mailboxes. Hotsheets are great but long winded and having the ability to simply schedule reports would be great.

It is not currently possible to produce queries or reports on tasks that have been created in People HR. It is also not possible to explort the task data manually via Excel or any other method.

Currently, if you run a report on sickness in the previous month, it will not include the long term cases that have not commenced in the previous month but are still ongoing during that month. The only workaround is to complete separate queries fo...

Add a Today option that dynamically updates queries each day to enable Greater than Today/Less than Today type reports which don't have to have the date changed manually every time the report is run. Additional options such as 1st/Last (or specifi...

Ability to duplicate existing built reports to easily ammend for different services/departments. Say I wanted to see DBS record for department A, and then for department B on seperate sheets. Rather than having to keep changing the filter I would ...

This will enable filtering and data sorting in chronological order. At the moment, every time I need to sort by date, I need to frist change the formatting of the whole column.