- Database logon is asked twice
- A database logon refers to old database
- Business Objects Enterprise (BOE) or Crystal Reports Server (CRS)
- Crystal Reports (CR)
Reproducing the Issue
- From CR open a report which contains dynamic parameters
- Change the data source location of the report
- Save the report into either BOE or CRS
- From Infoview run the report
- A Dynamic Cascading Prompt group of a managed report (report published to BOE or CRS) has its own database connection.
- After the report is saved into either BOE or CRS, the Dynamic Cascading Prompt group is automatically saved in Business View Manager (BVM).
- From Crystal Reports, only the database connection of the report itself can be changed.
- The database connection of the Dynamic Cascading Prompt is changed from BVM.
From ’View’ menu, check ‘Repository Explorer’
From the ‘Repository Explorer’ window, open the ‘Dynamic Cascading Prompts’ folder
Double-click on the ‘Data Connection’ object related to a dynamic parameter
Select Edit Connection
Set up the connection to the new database
Repeat steps 4,5,6 and 7 for each dynamic parameter used within the report
Resolution without using BVM:
- From CR, open the report
- Set the database location to the new database
- Edit an existing dynamic parameter
- Select the fields to which the parameter refers
- Repeat steps 3 and 4 for each dynamic parameter
Please note that both resolutions can be applied if the SAP Integration KIT and ERP server are used.
How to change the Database location of a managed report that contains dynamic parameters , 8178036 LOV, List of Values, INT , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem