SAP Knowledge Base Article - Public

3132567 - Dynamic Data Connection Parameter disappears from the report design when opening the report in Crystal Reports

Symptom

  • Parameter disapears.
  • Dynamic Data Connection Parameter removed from the report.
  • After updating the Dynamic Data Connection in the Business View Manager, when opening a report based on the Business View using the Dynamic Data Connection, the Dynamic Data Connection Parameter is removed from the report design. 

Environment

  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
       
  • SAP BusinessObjects Client Tools 4.2
  • SAP BusinessObjects Client Tools 4.3
       
  • SAP BusinessObjects Business Intelligence platform 4.2
  • SAP BusinessObjects Business Intelligence platform 4.3 

Reproducing the Issue

  1. In Crystal Reports, create a report based on a Business View based on a Dynamic Data Connection.
  2. Insert the Dynamic Data Connection parameter on the report to display the connection selected.
  3. Save and close the report.
  4. In the Business View Manager, update the Dynamic Data Connection.
  5. In Crystal Reports, open the report, and notice the Dynamic Data Connection parameter is removed from the report design.

Cause

  • After updating the Dynamic Data Connection in the Business View Manager, the Dynamic Data Connection Parameter name changed.
       
  • Since the Dynamic Data Connection Parameter name change, it cannot be map it to the orginal one, and it is therefore removed from the report design when opening the reports based on the Business View with Dynamic Data Connection in Crystal Reports.
           
  • The reason the Dynamic Data Connection Parameter name changed, it is because orginally the Dynamic Data Connection was created on a computer, and in Business View Manager set to use a different language. And the Dynamic Data Connection Parameter name is dynamically generated based on the language of the application and MS Windows. The name of the parameter is the name of the Dynamic Data Connection, plus the word "Parameter" in the language used by the application.

    For example: If Dynamic Data Connection name is: ABC, and the language use is for theBusiness View Manager and MS Windows is French, then the Dynamic Data Connection Parameter name will be:

         ABC Paramètre

    And later on, on a different computer, if the language used for Business View Manager and MS Windows is English, then the name of the Dynamic Data Connection will now be:
      
         ABC Parameter

    Since the Dynamic Data Connection Parameter name changed, then when opening the report in Crystal Reports, it removes the parameter from the report design, because it can no longer be mapped to the original parameter since the parameter name is different.

Resolution

  • Update the Dynamic Data Connection in the Business View Manager on a computer with the same language as it was originally designed. ( For example: French )
       
    1. On a MS Windows computer with the display language set to language the Dynamic Data Connection was originaly created under. ( For example: French ) Install the SAP BusinessObjects Client Tools ( which included the Business View Manager ) and include in the installation the language in which the Dynamic Data Connection was originally designed in. ( For example: French )
          
    2. On this computer, in the Business View Manager, modify the Dynamic Data Connection.
           
      The Dynamic Data Connection Parameter will stay the same as it was originally created since the language for MS Windows, and the application is the same as when the Dynamic Data Connection was originally created, therefore when opening the report in Crystal Reports, it will keep the Dynamic Data Connection parameter on the report design, since the parameter name is the same.

Keywords

CR, BVM , 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