SAP Knowledge Base Article - Public

1228341 - Crystal Reports Database Connector Error: ‘If tables are already linked then the join type cannot change’

Symptom

  • From Business View Manager, open ‘Data Foundation’;
  • Change link or create new link between two tables;
  • From Crystal Reports, error: Failed to retrieve data from the database. Database Connector Error: ‘If tables are already linked then the join type cannot change’.
  •  

Reproducing the Issue

Environment:

  • Crystal Reports Server/Business Objects Enterprise XI R1 or Crystal Reports Server/Business Objects Enterprise XI R2;
  • Crystal Reports XI Release 1 or Crystal Reports Release 2;
  •  

Cause

Limitation of the query engine caused by the requirement of having multiple links between two tables

Resolution

 

This is issue is by design and cannot be fixed with the current releases (Crystal Reports XI Release 1 and Release 2);

 

Workarounds:

 

  1. Make the joins as simple as possible; consider the use of Views, subreports and Stored Procedures;
  2. Use of ‘AddCommand’ option when this is available: AddCommand allows you to write your own SQL query. Please find ‘Defining an SQL Command’ in the ‘Crystal Reports Online Help’.

Keywords

KBA , BI , Business intelligence solutions , Problem

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2