SAP Knowledge Base Article - Public

1804875 - Unable to add tables in Crystal Reports.

Symptom

Unable to add tables in new and existing Crystal Reports.

Environment

Crystal Reports 2008/2011.

Reproducing the Issue

  1. Open new or existing crystal report in designer.
  2. Go to Database > Database Expert.
  3. Select the connection and select tables.

Cause

  • Crystal Reports process links automatically when ‘Automatic Smart Linking’ option is enabled.
  • Crystal Reports automatically tries to link tables by key or text.

Resolution

  1. In Crystal Reports designer, go to File > Options.
  2. Go to Database > under Advanced Options go to Automatic Smart Linking.
  3. Uncheck Automatic Smart Linking option and click on OK.

Keywords

Crystal Report,tables. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1