Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos


Blog post explain the steps to be followed to connect webservice as a datasource from Crystal report.

Watch this video to connect webservice as a datasource.

In some cases, accessing datasource will not be smooth as shown in the youtube video. You may get issues like I mentioned below.

Issue: While connecting the data source, if you are not getting service, port and methods field value. Then, it is not possible to create CR report.

(In this case, Webservice URL is generated from SAP system.)


     Step 1. Installing Certificates

// First check the java path and try to execute both Javac and java commands. If anyone of these commands are not working, try to install new java s/w and change the path in Environmental variables.

               a.Google and download from github.

               b. javac

               c. java installcert <Servername>

               d. keytool -exportcert -alias <Servername> -1 -keystore jssecacerts -storepass changeit -file <Servername>.cer

               e. keytool -importcert -alias <Servername> -1 -keystore "C:\Program Files\Java\jdk1.8.0_101\jre\lib\security\cacerts" -storepass changeit -file                                  <Servername>.cer

Note: for more information, read "READ ME" document in the github.

     Step 2. Crystal report configuration (If Java software installed as mentioned in the Step 1)

Search for the file "CRConfig.xml" in

C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java

Open “CRConfig.xml” file and edit the "JavaDir32 "parameter to new installed java path

Example: <JavaDir32>C:\Program Files\Java\jdk1.8.0_101\jre\bin</JavaDir32>

Conclusion: After following all these steps, restart the Crystal report and try once again. Hope it works for you.

Thanks to my colleague Phoebe.

Best wishes,