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".
- Create two different connections while creating a report and add the required tables from them in "Database Expert"
- 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.
- 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 Business View Manager , How To
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports 2011