SAP Knowledge Base Article - Public

1615056 - How to connect to SAP datasources from Crystal Reports?

Symptom

  • Failed to connect to SAP Tables.
  • Report returns no data, when connecting to SAP Tables from Crystal Reports.
  • Error when reporting off an SAP BW BEx Query in Crystal Reports.
  • Crystal Reports list many different ways to connect to an SAP System, but users are still not able to connect.

Environment

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

Reproducing the Issue

  1. In Crystal Reports, create a new report.
       
  2. Select one of the following connection:
    • SAP BW MDX Query
    • SAP Info sets
    • SAP Operational Data Store
    • SAP Table, Cluster, or Function
        
  3. It fails to connect, or there is no data, or have other issues.

Cause

  • From Crystal Reports 2011, the SAP Connectivity is included in the default installation of the product on the client side, but in order to successfully connect to an SAP System from Crystal Reports, authorizations needs to be set on the SAP Systems, and functions Crystal Reports uses to connect to the SAP System needs to be loaded on the SAP System. Failing to so will result in a wide range of issues.

Resolution

  • To successfully connect and report from an SAP data source from Crystal Reports:
    • Load the SAP Integration Kit Transports to the SAP System.
    • Set the required Authorizations on the SAP System for the SAP User that will connect to the SAP System from Crystal Reports.
    • Ensure the SAP Gateway allows external application, like Crystal Reports to connect to the SAP System.
             
        
  • Load the SAP Integration Kit Transports to the SAP System corresponding to the vesion of Crystal Reports used:
     
    It is very important to load the correct version of the SAP Integration Kit Transports because the transports load the functions Crystal Reports uses to connect to the SAP System, and if the version of the functions does not correspond to the version of Crystal Reports used, then issue will occur.
           
     
    1. The SAP Integration Kit Transports that are required to load on your SAP System are located in Crystal Reports production installation and product update, therefore unzip  the product installation package or product update corresponding to the version of Crystal Reports you are currently using.   
                  
    2. Navigate to the following folder: \Collaterals\Add-Ons\SAP\Transports
        
    3. In the folder, the following file contains the versions of the SAP Integration Kit Transports to load on your SAP System: transports_EN.txt

      Below is an example of an extract of the content of the file displaying the version of the SAP Integration Kit Transports to load: 

      * Open SQL Connectivity transport (K900754.R21 and R900754.R21)
      * Info Set Connectivity transport (K900780.r21 and R900780.r21)
      * Row-level Security Definition transport (K900689.r21 and R900689.r21)
      * Cluster Definition transport (K900690.r21 and R900690.r21)
      * Authentication Helpers transport (K900691.r21 and R900691.r21)
      ...  

    4. The Transport files to load are located in the following folders: 
         
                \Collaterals\Add-Ons\SAP\Transports\unicode_compatible\cofiles

                \Collaterals\Add-Ons\SAP\Transports\unicode_compatible\data
          
    5. Contact your SAP BASIS administrators to request them to load the SAP Integration Kit Transports on the SAP System.
        
      Note:
      You do not have to load all the SAP Integration Kit Transports, but only those required for the type of connectivity used. 
      For more information, see the Transports chapter in the following document:
        
                 SAP BusinessObjects Integration for SAP Solutions Installation and Administration Guide
         
          
         
  • Set the required Authorizations on the SAP System for the SAP Users that will connect to the SAP System
     
    1. The required Authorizations are listed in the Authorizations chapter of the following document:
       
                 SAP BusinessObjects Integration for SAP Solutions Installation and Administration Guide
                
      Note: The document was written for an older version of Crystal Reports, but the Authorizations and Transports information remain the same for Crystal Reports 2011, 2013 and 2016 
               
    2. Request the SAP BASIS Administrator to set the required Authorizations for the SAP Users that will be used to connect to the SAP System.
       
       
       
  • Configuring the SAP Gateway
        
    • To confirm the SAP Gateway is configured to allow your user, your computer, and external application to communicate with the SAP System, see the following SAP Knowledge Base Article:
             
                   1408081 Basic settings for reg_info and sec_info
           
    • SAP Gateway configuration should be performed by the SAP BASIS Administrator, If you have any questions or issues setting security for the SAP Gateway, then create an incident for the SAP Gateway support, under the component: BC-CST-GW

See Also

1345919 - How do you load transports provided within the SAP Integration Kit into SAP BW system

Keywords

CR, SAP IK , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

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

Attachments

xi31_sp5_bip_sap_inst_en.pdf