Skip to main content

Сreate your сustom report

Learn how to create your own report

Updated today

Custom reports let you build fully customized reports to view data you need and save it for reuse, sharing, or export. In the report builder, the key decision is what data source you want to work with:

  • Employee fields / Employee tables - best for a “current state” snapshot (what the data looks like now).

  • Historical data - best when you need a report that shows changes over time (what changed, when it became effective, and what the new value is).

Note: We're rolling out this feature gradually. If you’d like to test it, please contact us at support@peopleforce.io

📊 You can track changes only for fields that are marked as Historical in the People data section. If a field isn’t labelled as historical, it won’t be available for Historical data reports.


Custom reports with Employee fields and tables

Use this option when you need a clean snapshot of employee data for day-to-day work and reporting. It’s great for building lists and exports like:

  • team lists for managers (department, location, manager, contacts)

  • reports based on employee custom fields (e.g., office, grade, equipment, payroll info, etc.)

  • table-based reports (when your data lives in employee tables and you want to export or share it)

How to create it

  1. Go to the Reports > Custom section.

  2. Click on the New button to create a new custom report.

  3. In the Details tab, name the report and add the description if needed.

  4. In the Data source tab, you can select the source for your report. You have two options:

    1. generate the report using employee fields only;

    2. generate the report from employee tables, with employee fields still available for selection. Simply choose the table you want to include in the report.

  5. In the Configure tab, choose the columns you want to include in the report. By default, the report includes the employee fields: Employee ID, First Name, and Last Name. You can reorder them by dragging and dropping them, and add any additional fields with the corresponding arrows:

    1. If your report includes only employee fields, simply move fields from the left column to the right column to add them.

    2. If you've selected an employee table as your data source, columns from that table will automatically appear in the right column. You can also add additional employee fields to combine data from both employee fields and tables in the report.

  6. In the Filter and share tab, you can apply filters to ensure that the custom report is related to specific employees, departments, divisions, positions, or other criteria. If no filters are applied, the report will be generated for all employees in the company.

  7. Additionally, you can include terminated employees in the report. To do so, simply mark the checkbox provided.

  8. In the Share this report section, you can control which employees have access to the custom report you've generated. Use the employee assignment filter to specify categories and attributes for employees who will be granted access. Selected employees will then be able to view the report in the Reports section.

  9. Save the report.

Custom reports to check historical changes

You can use a report with historical data when you want a report that shows only changes, not the current snapshot.

It works like the standard history reports, but it’s much more flexible because you can combine changes from different areas in one report and still add regular employee fields for context.

You can use it to track changes for anything that appears as Historical in the report builder, for example:

  • department and team changes

  • location changes (office/remote/region)

  • position changes and other “effective on” updates

  • manager changes

  • job catalog updates (job profile / job group / job level)

  • salary and additional compensation changes

  • any other fields marked as Historical in People data

How to create it

  1. Go to the Reports > Custom section.

  2. Click on the New button to create a new custom report.

  3. In the Details tab, name the report and add the description if needed.

  4. In the Data source tab, select Historical data type.

  5. In the Configure tab, choose the columns you want to include in the report. By default, the report includes the employee fields: Employee ID, First Name, Last Name and Effective on (so you can see the date when the change takes effect). You can reorder them by dragging and dropping them, and add any fields marked as Historical or any regular employee fields you want for context (like department, manager, location, employee identifiers) with the corresponding arrows.

  6. In the Filter and share tab, you can apply filters to ensure that the custom report is related to specific employees, departments, divisions, positions, or other criteria. If no filters are applied, the report will be generated for all employees in the company.

  7. Additionally, you can include terminated employees in the report. To do so, simply mark the checkbox provided.

  8. In the Share this report section, you can control which employees have access to the custom report you've generated. Use the employee assignment filter to specify categories and attributes for employees who will be granted access. Selected employees will then be able to view the report in the Reports section.

  9. Save the report.

When you use Historical data, the report shows entries only for employees who had changes during the selected period.

Filter the report data

The report includes various filters, such as Position, Department, Division, Location, Employment types, etc. By using these filters, you can customize your search and obtain specific information that interests you.

Manage your report

You can manage your created reports in a variety of ways, such as editing, exporting to Excel or CSV formats, or deleting them from the system. To accomplish any of these actions, simply go to the custom report and click on the three dots icon, then select the desired option.

When your export is ready, a notification will appear in the notification bar - click it to download the report to your computer.


Did this answer your question?