Sage 300 Custom reports prompting for SQL login

To get around this issue, re-open the customized report in Crystal Report Designer.

1. From the Database menu, select Set Datasource Location
2. Click on Create New Connection
3. Select ODBC (RDO)
4. Specify a data source to be used for the report.
5. Click Next.
6. Enter a valid SQL user ID and password.
7. Select a database.
8. DO NOT select the checkbox for Trusted Connection.
9. Click Finish
10. From the Database menu, run Verify Database. Make sure it passes without errors.
11. Save and report and try printing it from Sage 300 ERP.