Symptom
- Is it possible to use multiple data sources for a report?
- Can we add tables from different data source to a report in Crystal Reports?
For example: It is possible to add to a report a table from database ABC, and link it to data from a spreadsheet?
Environment
- SAP Crystal Reports 2008
- SAP Crystal Reports 2011
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
Resolution
-
It is possible to add multiple data sources to a report in Crystal Reports.
-
IMPORTANT NOTE: Connecting to multiple sources will decrease the report performance. For more details, see the SAP Knowledge Base Article:
1260284 - Slow performance when reporting from multiple data sources in Crystal Reports
Keywords
Multiple Datasouce, One or more Datasources, CR dataproviders. , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
Crystal Reports 2008 V0 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016