3670904 - How to convert a Crystal Reports for Enterprise report based on an SAP BW Query, to Crystal Reports?

• Crystal Reports for Enterprise software has been deprecated, and removed from SAP BusinessObjects BI 2025.
• How to convert a report created in Crystal Reports for Enterprise connecting to an SAP BW Query (BICS) to Crystal Reports?

• SAP Crystal Reports 2020
• SAP Crystal Reports 2025
    
• SAP Crystal Reports for Enterprise 4.3

• The functionality to connect to an SAP BW Query using BICS connection have been added in:
     
  
  • Crystal Reports 2020 - Support Pack 05
  • Crystal Reports 2025
          
• Therefore use the above version of Crystal Reports to convert a report based on an SAP BW Query from Crystal Reports for Enterprise, to Crystal Reports.
                
• Software required to convert a report based on an SAP BW Query from Crystal Reports for Enterprise, to Crystal Reports:
     
  
  • Crystal Reports 2020 - Support Pack 05
  • Crystal Reports for Enterprise 4.3
  • SAP BusinessObjects Business Intelligence platform 4.3
      
    OR
       
  • Crystal Reports 2025
  • SAP BusinessObjects Business Intelligence platform 2025
  • Crystal Reports for Enterprise 4.3
  • SAP BusinessObjects Business Intelligence platform 4.3
          

1. In Crystal Reports for Enterprise 4.3 or below, take note of the query used by the report based on the SAP BW Query:
   
   1.1  In Crystal Reports for Enterprise 4.3 or below, open the report based on the SAP BW Query.
   1.2  Under the menu "Data", select "Edit Data Sources..."
   1.3  In "Edit Query", take notes of the Result Objects and Query Filters, or a screenshot.
   
             This information is needed because the query will need to be recreated when converting the report
             from Crystal Reports for Enterprise, to Crystal Reports.
   
   1.4 Click "Cancel" 
      
2. Still in Crystal Reports for Enterprise 4.3, or below, take note of the SAP BW Connection, and the SAP BW Query used by the report: 
     
   2.1  In Crystal Reports for Enterprise 4.3 or below, open the report based on the SAP BW Query.  
   2.2  In the Data Explorer pane on the left side, under "Result Objects", take note of the SAP BW Connection used. ( Name beside the blue cylinder )   
   2.3  Under the connection, take note of the SAP BW Query name used by the report.  
   2.4  Close the report.
          
3. If you are migrating to SAP BusinessObjects BI 2025:
   Migrate the Crystal Reports for Enterprise report based on SAP BW Query with dependencies, from SAP BusinessObjects BI 4.3 or lower, to SAP BusinessObjects BI 2025 
          
4. In Crystal Reports 2020 - SP04, or Crystal Reports 2025, perform a Set Datasource Location to the same SAP BW Query
   
   4.1  In Crystal Reports 2025 - SP04, or Crystal Reports 2025, open the Crystal Reports for Enterprise report based on an SAP BW Query  
   4.2  The following message will display, click "OK"
   
           "This is an SAP Crystal Reports for Enterprise report.
             If you choose to open this report, you will have to set the data source.
             In case your report takes advantage of any features specific to SAP Crystal Reports for Enterprise,
             be sure to verify your report thoroughly" 
   
   4.3  Under the menu "Database", select "Set Datasource Location..."
   4.4  In "Set Datasource Location", under "Replace with", double click on "Create New Connection"
   4.5  In the list of available data sources, click on "SAP BW (DSL)"
   4.6  In "Select a BW query", select the SAP BW connection by double clicking on it.
   4.7  Search for the SAP BW Query the report used, select it, and click "OK"
   4.8  In the "Query Panel", add in Result Objects, and the Query Filters. The same Dimensions, Measures, and Filters the report used before.
   
            IMPORTANT NOTE: If not all the same Dimensions, Measures and Filters are added, then the database fields missing will be
            removed from the report. If not all the same Filter(s) is added, then the report will return a different data set, therefore
            it is really important that all the same Dimensions, Measures and Filters are added to the Query Panel. 
   
    4.9  Click "OK"
   
    4.10  Back to "Set Datasource Location" window, under "Current Data Source", select the SAP BW Query ( Blue square ) 
   
    4.11  In the section "Replace with", under "SAP BW (DSL)", select the SAP BW Query, then click on the button "Update"
   
    4.12 It may show the Mapping screen when not all the Dimensions, Measures and Filters matched.
            In which case each fields needs to be mapped manually. Once completed, click "Close"
            If all the objects match, it will display the message: "Data Source replaced" 
   
    4.13 Click "Close"
      
5. Save the updated report under a different name, if you want to keep a copy of the original report.
     
6. Test the report as some functionalities are not supported, like Delegated Measures. 
   If the report used Delegated Measures, remove it from the report, and create summaries on the Measures in Crystal Reports.

CR4E, CR for Enterprise, CRFE, CR for E, BW Query, BEx Query, BICS, DSL , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

SAP Crystal Reports 2020 ; SAP Crystal Reports 2025