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 

  • Custom reports prompting for SQL login

    Products

    Sage 300

    Description

    When printing customized reports within Sage 300 ERP, the customer is prompted for a MS SQL security login.

     

    Resolution

    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.

    Click Next.

    Enter a valid SQL user ID and password.

    Select a database.

     

    DO NOT select the checkbox for Trusted Connection.

    Click Finish

    From the Database menu, run Verify Database. Make sure it passes without errors.

    Save and report and try printing it from Sage 300 ERP.

    Category

    Configuration

    Data and database

    ODBC

    Settings and preferences

     

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

Reply
  • Custom reports prompting for SQL login

    Products

    Sage 300

    Description

    When printing customized reports within Sage 300 ERP, the customer is prompted for a MS SQL security login.

     

    Resolution

    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.

    Click Next.

    Enter a valid SQL user ID and password.

    Select a database.

     

    DO NOT select the checkbox for Trusted Connection.

    Click Finish

    From the Database menu, run Verify Database. Make sure it passes without errors.

    Save and report and try printing it from Sage 300 ERP.

    Category

    Configuration

    Data and database

    ODBC

    Settings and preferences

     

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

Children
No Data