INFORMATIONAL ** THIS INFORMATION HAS NOT BEEN VERIFIED **

SQL Error: Incorrect Syntax Near '=' when running a new report

Entry Type: Informational

Product: Sage ERP MAS 500

Application: SMI Report Manager

Version Reported: All

Subject:

SQL Error: Incorrect Syntax Near '=' when running a new report using the data container ( 'Financial Reports 2-x').

Possible Resolution:

The reason the error occurs is because the data container's ( 'Financial Reports 2-x') join contains pass through variables.  Any report that uses this container needs to have the following parameters added:

1. Company Name
2. Financial Year
3. Budget set

These are the same parameters defined in the Financial Reports 2-x report that uses the data container ( 'Financial Reports 2-x').