I have tried to create customized report for Sage 300. As long ODBC does not save sql credentials then every time I run the reports, reports prompt for user name and password to access Databases.
Custom reports prompting for SQL login
Sage 300 Online
When printing customized reports within Sage 300 ERP, the customer is prompted for a MS SQL security login.
In one case it is the Order Entry Invoice that is not able to print.
Customer has made a change to the customization directories (migrated server) and did not copy the oerpt.ini file which contains the report parameters.
Copy the oerpt.ini file to the correct folder in the customization directories.
Printing and Reporting
ID:59313Last Modified Date:6-10-2019
To get around this issue, re-open the customized report in Crystal Report Designer.
From the Database menu, select Set Datasource Location
Click on Create New Connection
Select ODBC (RDO)
Specify a data source to be used for the report.
Enter a valid SQL user ID and password.
Select a database.
DO NOT select the checkbox for Trusted Connection.
From the Database menu, run Verify Database. Make sure it passes without errors.
Save and report and try printing it from Sage 300 ERP.
Data and database
Settings and preferences
ID:23946Last Modified Date:6-10-2019