SAP Knowledge Base Article - Public

1284930 - Can we connect to multiple data sources on a report in Crystal Reports?

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