How to create a custom employee report?

How to create a custom employee report?

Creating a custom employee report involves the following:

  • Naming the report

  • Specifying the report criteria along with filters to retrieve specific data

  • Selecting the data fields to be included in the report

At the top of your dashboard, click the module access icon > Data and Reports > Custom Reports.
  1. In the top right, click the New Employee Report button.

  2. In the Name field, enter the name of the report. This is a mandatory field.

  3. Select the report criteria.


For each criterion, specific operator commands must be applied. The following operators are available.


Field Type

Operators

Examples

Date Fields

  • Greater than

  • Less than

  • Equals

  • Joining date | Greater than | 1 Jun 2015 – Employees joined after June 1, 2015.

  • Joining Date | Equals | 30 Jun 2015 – Employees admitted on June 30, 2015.

  • Date of Birth | Greater than | 01 May 1970 but Less than | 30 June 1970 – Employees whose date of birth is between May 1, 1970 and June 30, 1970. 

Text Fields

  • Like

  • Begins with

  • Equals

  • Employee number | Like | BO – Employees whose employee number contains the characters ‘BO’.

  • Last Name | Begins with | C – Employees whose last name begins with ‘C’. 

  • Blood Group | Equals | O – Employees whose blood group is ‘O’.

Search Fields

NA

  • Employee department – Enter the department name or a few characters and select the department.

  • Employee grade – Enter the employee grade or enter a few characters and select the grade.



The input criteria will look like this.




  1. Select the data fields to be included in the report by clicking the arrow icon beside each field. Selected fields are moved to the right.



The order in which the data fields appear in the report can be arranged using the arrow icons beside the selected fields.




Use the arrow icon to remove a data field from the report.




If necessary, the report headers can also be edited.




  1. Click the Save button at the bottom of the page. 


  1. Click Show Report. Data matching the given filter criteria will be displayed.



The data can be sorted by clicking the headers.

  1. In the top right, click the Export CSV button to download the report in CSV format.


    • Related Articles

    • How do I create a custom report?

      The custom report module can be used to create reports that contain fields of the user's choice. Custom Reports can be created for students or employees. It is very useful when administrative reports need to be created to view lists of students or ...
    • About custom report

      Custom Reports plugin to create custom reports using the admission information of students and employees. For example, you may need a report on the names of students who were admitted on a particular date, or, you may need a report on the student ...
    • Is it possible to edit a custom report? How can I delete a custom report?

      An existing custom student report/ employee report cannot be edited. If any change needs to be made to the report, delete the report and create a new report. To delete a custom report: At the top of your dashboard, click the module access icon > Data ...
    • How can I create a custom student report?

      Creating a custom student report involves the following: Naming the report Specifying the report criteria along with filters to retrieve specific data Selecting the data fields to be included in the report At the top of your dashboard, click the ...
    • How can I create custom reminder?

      At the top of your dashboard, click the module access icon > Administration > Reminders > Create Custom Reminders to open the Create Custom Reminders page. In the Reminder name field, enter the name of the event/news. Select the date the reminder ...