Skip to Content
Author's profile photo Former Member

Connecting Webservice as a datasource


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,


Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.