3278961 - How to point a Dynamic Parameter to another data source in Crystal Reports?

• How to change the data source of a dynamic parameter?
• After pointing a report to another database, the dynamic parameter still point to the previous data source. How to point the Dynamic Parameter to another datatabase?

• SAP Crystal Reports 2013
• SAP Crystal Reports 2016
• SAP Crystal Reports 2020
       
• SAP BusinessObjects Business Inteligence platform 4.1
• SAP BusinessObjects Business Inteligence platform 4.2
• SAP BusinessObjects Business Inteligence platform 4.3 

• Reports using Dynamic Parameters saved on the SAP BusinessObjects Business Intelligence platform, stores the dynamic parameters in the SAP BusinessObjects Repository.
         
• The Dynamic Parameters does not use the report data sources, but the data sources stored in the SAP BusinessObjects Repository, and this is why, when pointing the report to a new data source, the Dynamic Parameters still point to the original data source.

• To change the data source the Dynamic Parameter points to, update the Data Connection it is based on, in the Business View Manager.  The general steps are:
     
1. In Crystal Reports, identify the prompt group the Dynamic Parameter is based on.
2. In the Business View Manager, find the Data Connection the Prompt Group is based on.
3. In the Business View Manager, point the Data Connection to the new data source.
       
       

1. In Crystal Reports, identify the prompt group the Dynamic Parameter is based on.
     
1. 1.1 In Crystal Reports, under the menu "File", select "Open"
     
2. 1.2 In the Open window, in the left pane, click on "Enterprise"
   
             
     
3. 1.3 Log On to the SAP BusinessObjects Enterprise platform
     
4. 1.4 Open the report that contains the Dynamic Parameter from the SAP BusinessObjects BI Server.
     
5. 1.5 In the Field Explorer pane, under "Parameters", right click on the dynamic parameter and select: "Edit"
   
            
     
6. 1.6 In the "Parameter" window, take note of the name of the List of Values Prompt Group associated with the parameter.
     
         The List of Values Prompt Group name is located under "Choose a Data Source",
7.        on the right side of "Existing". Take note of the Prompt Group.
   
              
     
8. 1.8 Click "Cancel" to close the parameter window.
     
     
2. In the Business View Manager, find the Data Connection the Prompt Group is based on.
   
   
1. 2.1 Start the Business View Manager, and login to the SAP BusinessObjects BI Server.
        ( Note: If the Business View Manager is not installed, to download it, see the SAP Knowledge Base Article 2506155 )
     
2. 2.2 If the Welcome to Business View Manager window display, click "Cancel"
   
             
    
3. 2.3 In the Repository Explorer pane, find the List of Values Prompt Group, and select it.
         ( Note: If there is no "Repository Explorer" pane, go under the menu "View", and select "Repository Explorer" )
          
4. 2.4 In Repository Explorer pane toolbar, in the upper right corner, click on "Show Referenced Objects"
   
             
     
5. 2.5 It will open the Referenced Objects window showing all the associated objects. Expend all the levels, and it will show:
• List of Values (LOV)
• Business View
• Business Element
• Data Foundation
• Data Connection
     
6. 2.6 The last object, with a yellow cylinder icon is the Data Connection.
         Take note of the Data Connection name.
   
                      
   
   
7. 2.7 Click "Close", to close the window.
   
   
   
3. In the Business View Manager, point the Data Connection to the new data source.
     
1. 3.1 In the Business View Manager, in the Repository Explorer pane, find the Data Connection.
   
   
2. 3.2 To open the Data Connection, double click on it, and it will open on the left side.
   
            
     
3. 3.3 Under the menu "Edit", select "Edit Connection..."
   
          
     
4. 3.4 In "Choose a Data Source", select the new data source, and click "OK"
   
             
     
5. 3.5 In "Set Data Connection Password":
• User Name : Enter the database user name
• Password   : Enter the database password
• Confirm password : Re-type the database password
    
6. 3.6 Set the option "Runtime Prompt Mode" to: Never prompt
   
           
     
7. 3.7 Click "OK"
     
8. 3.8 To test the connection, go under the menu "Tools", and select "Test Connectivity"
   
          If the connection is successfull, it will display the message:
      
            "Connection test completed successfully"
      
9. 3.9 Under the menu "File", select "Save"

 CR, LOV , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020