Connecting Webservice as a datasource
Hi,
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.
https://www.youtube.com/watch?v=4zQTxQIZT-4
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.)
Solution
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 installcert.java from github.
b. javac installcert.java
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,
Suresh