Error 1805: "SQL Column – Too many queries"
MYOB Exo Payroll has many reports available for printing. The selection of which report to print depends on what information is to be reported on. When printing reports, there are different options and selection ranges that can have an effect on the information being displayed.
Some errors that may occur when printing reports, such as an 'Error 1805: SQL Column - Too many queries', can be caused by the options and selection ranges being used in the report.
These errors can occur due to having too large a range selected or there are too many selections made for the report. Examples of this include:
- Running a report with a very large number of employees selected rather than specifying the employees that the report is for.
- Having made selections in many of the Selection Ranges fields for a report.
To resolve an Error 1805, you'll need to:
- Make adjustments to the selection ranges so that they are more suitable for producing the desired report.
- Perform a Force Upgrade in the software. This can be done following the instructions below.
Need more help? You can open the online help by pressing F1 on your keyboard while in your software.
You can also find more help resources on the MYOB Exo Employer Services Education Centre for Australia or New Zealand.