Skip to Main Content
PeopleHR Ideas Portal
ADD A NEW IDEA

Queries/Reporting

Showing 105

Query of people who have had no sickness over a period of time

It would be useful to be able to pull off a report of staff who haven't taken any time of for sickness over a chosen period of time as this is a big achievement.
Guest about 1 year ago in Queries/Reporting 0 Open for Voting

Sickness % from Planner to be added to Queries for Reporting

Is there a way to report on the sickness % that you can see on the employees planner top of screen with queries. We can't seem to find where this outputs to so we can report on Sickness Absence rather than having to take this and complete calculat...
Guest over 1 year ago in Queries/Reporting 2 Open for Voting

Only Managers can see employees salary

Currently when an employee has an additional reports to set up on their personal tab (such as a team leader) both the Team leader and the actual reports to manager can see employees salaries. I would like only the reports to, to be able to see sal...
Rebecca Radford over 1 year ago in Queries/Reporting 0 Open for Voting

Age & Length of Service Query Outputs

I've created a hotsheet that contains the age and length of service for our employees. When it exports the fields are shown as text in the format "46 years, 9 months". I want them to just have the full years - so 46 years. It would be good to have...
Guest 12 months ago in Queries/Reporting 0 Open for Voting

Query Column Order

When creating a Query I would like the columns to be in a particular order every time I run / access the query. I select the fields that I want in the Query, and then I am able move the columns to where I want them to be, so that when I export to ...
Michala Warren 12 months ago in Queries/Reporting 1 Open for Voting

Adding 'Date last opened' on queries page.

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.
Deveena Dissanayake 6 months ago in Queries/Reporting 0 Open for Voting

Showing an assignment as approved if timesheet approved

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...
Guest 6 months ago in Queries/Reporting 0 Open for Voting

Improvement to Excel download from Queries

When certain numerical data is exported to Excel from Queries, it comes out as a text file e.g. length of service dates and dates/days of birth (e.g. when looking at age). This means that when you try to sort on Excel it does it alphabetical rathe...
Claire Harrison over 1 year ago in Queries/Reporting 0 Open for Voting

Printing expenses and receipts

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...
Guest 5 months ago in Queries/Reporting 1 Open for Voting

Query to have a most recent record option

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 ...
Hannah Dougherty 7 months ago in Queries/Reporting 0 Open for Voting