Reports and Queries

Find out how to produce varied queries and reports from your company data in People®

18 articles in this collection
Written by Abbi Melville, Jason Sturman, and Sat Sindhar

Holiday entitlement accrued to date

Build a report on how many days/hours entitlement pro rata.
Written by Abbi Melville
Updated over a week ago

Historical Salary Report

Build a query on all salary changes
Written by Abbi Melville
Updated over a week ago

Creating Queries

Written by Abbi Melville
Updated over a week ago

Queries - Filters and Options

An in-depth view of filters and options for creating queries
Written by Jason Sturman
Updated over a week ago

Create Charts Based on Queries

Video and description detailing how to create charts within the query builder
Written by Jason Sturman
Updated over a week ago

Remaining Holiday Report

Create a report showing employees remaining holiday balance
Written by Jason Sturman
Updated over a week ago

Payroll extract example

Learn how to build a quick query that shows changes for payroll.
Written by Sat Sindhar
Updated over a week ago

Create a Consolidated Timesheet Report in Excel

Written by Jason Sturman
Updated over a week ago

Printing Reports from Safari or Google Chrome

Details how to print a report opened in your safari or chrome browser
Written by Jason Sturman
Updated over a week ago

Point in Time Head Count Report

Create a query that shows you who's in work
Written by Jason Sturman
Updated over a week ago

Historical Changes

View changes made to an employee's record
Written by Abbi Melville
Updated over a week ago

Opening Query Builder Files in Excel

Guidance on query building files imported to Microsoft Excel
Written by Jason Sturman
Updated over a week ago

Login Audit

Run a query that tells you when each employee has logged in to the system
Written by Jason Sturman
Updated over a week ago

Indirect Reports

Written by Jason Sturman
Updated over a week ago

Exporting expense claims for accounts

Learn how to export expense claims from query builder for your accounting system.
Written by Sat Sindhar
Updated over a week ago

Filter a Query by a Specific Time Frame

Using the 'Greater than' and 'Less than' options to report on information within a chosen point in time.
Written by Abbi Melville
Updated over a week ago

Viewing Reports

A video overview
Written by Jason Sturman
Updated over a week ago

Printing Holiday and Absence Reports

How to print reports based on an employees holiday or absence
Written by Jason Sturman
Updated over a week ago