Symptom
- Failed to open the connection.
- Crystal Reports is prompting to logon to database when refreshing a report with dynamic parameter, then fails with the error: "Failed to open Connection"
Environment
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
- SAP Crystal Reports 2020
Reproducing the Issue
- In Crystal Reports, open a report using dynamic parameters.
- Refresh the report.
- When prompting for the database logon, enter a valid database user name and password.
- It then fails with the error: "Failed to open the connection."
Cause
- Data Access rights are not granted to the SAP BusinessObjects user for the relevant Data Connection used by the dynamic parameter List of Values (LOV)
Resolution
- Inthe Business View Manager, grant Data Access rights on the Data Connection used by the List of Values associated with the dynamic parameter :
- In Business View Manager find the relevant Data Connection for the List of Values used by the dynamic parameter.
- 1.1 Select the LOV in Repository Explorer window and click the "Show relevancy”
button at the top-right corner of the Repository Explorer window, - 1.2 It will show all the relevant objects including the Data Connection used by the List of Values.
- Right-click the Data Connection in Repository Explorer Window and select Edit rights.
- Click Preview button in the upper right corner of the dialog.
- Notice the Data Access is unchecked and Denied for the User or User Group.
- Explicitly grant the Data access to all required Groups.
- Restart Crystal Reports.
Keywords
CR, login failed, Parameter box empty , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020