SAP Knowledge Base Article - Public

1890961 - How to use multiple datasources in Crystal Reports?

Symptom

How to create a Crystal Report based on multiple datasources?

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011

Resolution

There are two basic and simple ways to achieve "Multiple datsource reporting in Crystal Reports".

  1. Create two different connections while creating a report and add the required tables from them in "Database Expert"
  2. Create the main report with Database  A. Insert a sub report in the main report and this Subreport would be based on Database B. Similarly add multiple Subreports to main report based on different databases.
  3. However to link between the tables from different datasources they need to have the same data type.

Keywords

multiple datasource, CR, sub report, Oracle, sql server, data connection , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011