How to use query builder for building customized reports?

greytHR enables you to build your own query set to generate a report. You can create ad-hoc and user-defined reports. It gives you the ability to pull out any data stored in the application. This page lists all the reports that you have built and saved in the past.

1. Click Reports > Query Builder.
2. Click . The Create Custom Report page appears.
3. In the Choose Fields section, choose the appropriate Available Fields and Output Fields.
4. Click Next.
5. In the Sort Order section, sort out the chosen Output Fields using the arrows provided.
6. Click Next.
7. In the Filter Criteria section, set the criteria to filter out the report. You can choose an existing criterion under the Quick tab or create a custom criteria under the Custom tab.
8. Click Next.
9. In the Results page, preview the result of the query before you further modify or download the report.
10. Click  to view or download your query set as a spreadsheet.

11. Click . A message appears displaying the save or incomplete fields. On successfully saving the query, the Query Builder page displays with the new report.

    Click the report name to edit query set or regenerate report.

    Watch the video to know more about report generation on greytHR