Crystal Report Credentials Prompt

Hello

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. 

Parents
  • Custom reports prompting for SQL login

    Products

    Sage 300

    Sage 300 Online

    Description

    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.

    Cause

    Customer has made a change to the customization directories (migrated server) and did not copy the oerpt.ini file which contains the report parameters.

     

    Resolution

    Copy the oerpt.ini file to the correct folder in the customization directories.

     

    Category

    Printing and Reporting

    Reports

    ID:59313Last Modified Date:6-10-2019 

Reply Children
No Data