Error: 'Reduce the number of employees in the report selection' when running reports

If your employees have Employee groups assigned and you run any report for some or all employees in this group, you may see the error:

'Reduce the number of employees in the report selection'

Let's run through the steps to resolve this. Try to run your report again when you complete the steps under a heading below. If the issue still occurs, continue to the steps under the next heading.

Refresh the employee list

1. Log into Sage 50 Payroll using the manager login.
2. Click Outline, then click All employees.
    TIP: This refreshes your employee list.
3. Click the required group and select the relevant employees.
4. Run your report again.

Run a Repair on your data

1. Close Sage 50 Payroll.
2. On the Windows desktop, right-click Sage 50 Payroll.
3. Click Properties, then click the Shortcut tab.
4. Click Open File Location.
5. Locate and double-click DBUtilities.exe.
6. Select the relevant company, then click Repair.
   NOTE: We recommend you run the Repair step twice.
   
7. Click OK, then click Close.

Create a new employee group

1. Create a new employee group and assign the relevant employees.
2. Remove the employees from the old group and delete it.
3. Run your report using the new employee group.

Workaround

If the above steps do not resolve the issue, as a workaround, you must run the report in 2 batches. If this fails, follow the steps below.

1. Add the report you'd like to run to your Report Favourites.
2. Close the Reports window, then select any employees to include in the report.
3. Click Favourites in the top left of your software.
4. Click Pre update reports or Post update reports as required.
5. Select and run your report from this location.

Upgrading your licence

Need a little more room? To add extra companies, users, employees or more to your software licence, leave your details and we'll be in touch.

Leave your details