Duplicated Data in Customized Reports Generator

When generating a customized report, you might encounter some duplicated data if the Report Builder filters were not applied correctly. In this article, you will find the steps needed to help you generate a customized report without any duplicated values.

How to Access Report Builder

Customized Reports Builder

Main Menu → Reports → General Reports → Customized Reports Generator 

On the Customized Reports Generator page, click the “Build a New Report” button.

Step 1: Active Filter 

On the Report Builder page,  under Employees, Health Insurance, Professional Data, and Salary Packages, you can find an “Active” check box. Check the “Active” box(es) under the type(s) of data  to add it as columns in the Report.

Once you check the “Active” box(es),  click on the filter icon on the right side of the page, then select “Yes “or “No” and click “Filter”. 

The active check box(es) are under Employees, Health Insurance, Professional Data, and Salary Packages. Below is how the  “Active”  filter works in these reports fields:

Active Filter Under Employees

Choose “Yes” to include currently active employees’ data, or “No” for terminated employees' data.

Active Filter Under Health Insurance
 Choose “Yes” to include the active health insurance added to employees or “No” for expired Insurance info.

Active Filter Under Professional Data 

Choose “Yes” to include the currently active employees’ professional info or “No”  for expired employee professional info.

Active Filter Under Salary Packages

Choose “Yes” to include the currently active employees’ salary package info, or “No” for expired or previous salary package info.

Step 2: Salary Packages Status filter.

Some data may be duplicated if you include more than one salary package type in the generated report.

Under Salary Packages, you’ll find the “Salary Package Status” check box. 

Check this box to activate this filter, then click the filter icon  and select the status of the employees’ salary packages you’d like to include in the customized report.

Salary Packages Status

Approved & Added by HR

Select “Approved” and “Added by HR” to include all active packages in the report, as they can only be added through these filters. 

You can also select any of the other filters or multiple to include the Salary Package status(es) you want in your report.