Queries/Reporting

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

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.

In our annual report and other MI reporting, we are asked to report on the avg LOS. We currently have to run the report then manually work it out.

Please can queries extract into excel/csv in the column order that you sort it on PeopleHR. It is really annoying when doing reports that you have to sort the columns in the order you need them outside the system. It would be so much easier to be ...

building hot sheets etc

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