SAP Knowledge Base Article - Public

1215396 - How to set a report data source location in Crystal Reports?

Symptom

  • How to point a report to a different data source?
  • How do you set the location of the database off which your report is based in Crystal Reports?

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016 
  • SAP Crystal Reports 2020

Resolution

  • In Crystal Reports, there are two ways to set the location of the data source your report points to, depending on your connection type:
       
    • For ODBC, OLEDB, JDBC and Native Connections
        
      1. In Crystal Reports, open the report.
          
      2. Under the menu 'Database', select: 'Set Datasource Location'
           
      3. In the 'Current Data Source' section, click the data source to be changed.

        Note: You must click each individual table in the data source one by one. If the data source is a stored procedure you will not see individual tables.
           
      4. In the 'Replace with' section, click the data source you want the report to use.
          
      5. Click 'Update'.
          
      6. Close the 'Set Datasource Location' window.
          
      7. Save the report.
           
        The report now points to the new database location.
           
            
    • For Native Connections Only
      1. In Crystal Reports, open the report.
          
      2. Under the menu 'Database', select: 'Set Datasource Location'
           
      3. In the 'Current Data Source' section, click 'Properties' to expand it, and right-click 'Database Name: <path to database>'.
           
      4. Click 'Edit' and then type the path to the new data source location.
            
      5. Close the 'Set Datasource Location' window.
          
      6. Save the report.
             
        The report now points to the new location.
 

Keywords

SET LOCATION MANUALLY MANUAL CHANGE DATABASE DATASOURCE SWITCH NEW DIFFERENT Crystal Reports Set Location Changing the database , c2012382 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020