INFORMATIONAL ** THIS INFORMATION HAS NOT BEEN VERIFIED **
"Incorrect Syntax near the keyword WHERE" error appears when running a report in Report Designer
Entry Type: Informational
Product:Sage MAS Intelligence
Application: Report Designer
Version Reported: 7.30
Subject:
"Incorrect Syntax near the keyword WHERE" error appears when running a report in Report Designer from MAS 500.
Possible Resolution:
This issue was only reproducible with a Customer's Database.
The reason this error occurred was because the SQL Join Query had been removed from the Financial Reports Container. If the query in the container is altered improperly or removed then you may receive errors when running the report.
To resolve, a backup of the Container was accessed and the Query was updated in the container.
Note: Sage Customer Support is not responsible for assisting with network security issues and takes no responsibility for changes made to your network or for errors in these instructions. Consult your network administrator before making changes.
