How to create a custom employee report
Name an employee report, filter by joining date, name, department or grade, choose the fields, then view and export it as CSV.
Creating a custom employee report involves naming the report, setting the criteria and filters, and selecting the data fields to include.
Steps
-
Go to Menu → Data and Reports → Custom Reports.
-
In the top right, click New Employee Report.
-
In the Name field, enter the report name (required).
-
Select the report criteria. Each criterion uses an operator, depending on the field type:
Field type Operators Examples Date fields Greater than, Less than, Equals Joining Date | Greater than | 1 Jun 2015: employees who joined after 1 June 2015. Text fields Like, Begins with, Equals Last Name | Begins with | A: employees whose last name begins with “A”. Search fields Not applicable Type a department or grade name and select it to filter the results. Screenshot — to be addedpublic/images/articles/custom-report-employee-1.png1Example of entered criteria -
Select the data fields by clicking the arrow icon next to each field; selected fields move to the right. Use the arrow icons to arrange their order.
Screenshot — to be addedpublic/images/articles/custom-report-employee-2.png2Selecting data fields If needed, you can also edit the report headers.
Screenshot — to be addedpublic/images/articles/custom-report-employee-3.png3Editing report headers -
Click Save, then click Show Report.
Screenshot — to be addedpublic/images/articles/custom-report-employee-4.png4Save button -
In the top right, click Export CSV to download the report in CSV format.
You can sort the data by clicking the column headers.
public/images/articles/custom-report-employee-5.pngRelated articles
Was this article helpful?
Thanks for your feedback!