SAP Knowledge Base Article - Public

2240889 - Dynamic Connection in Business Views displays the data only from the first connection in Crystal Reports

Symptom

When a Dynamic Connection is created in the Business View Manager with two different database connections, SAP Crystal Reports displays the data only from one or only from the first connection.

Environment

  • SAP Crystal Reports 2008/2011/2013
  • Dynamic Connection in Business View

Reproducing the Issue

  1. Create Dynamic Data Connection based on 2 different data connections in Business View Manager
  2. Launch SAP Crystal Reports designer
  3. Create a Crystal Report file based on Business View which uses Dynamic Data Connection
  4. Refresh the report choosing the 2nd data connection when prompted
  5. Notice that the data comes from the first data connection

Cause

Incorrect settings for Use Owner and Use Catalog properties of the data connections.

Resolution

Set the Use Catalog and Use Owner properties to False if the connections are used in Dynamic Data Connection.

  1. In Business View Manager, in the Repository explorer open the first connection
  2. In the 'Property Browser' dialog box, set the 'Use Owner' and 'Use Catalog' properties to 'False'
  3. Repeat the above steps for the second connection

Keywords

Dynamic Data Connection, Crystal, CR, DDC, same data reveived, not working , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , BI-RA-CR-BVM , Business View Manager , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016