Crystal Reports 2011 and Web Service consumption

building reports crystal reports
1

Hi
One of our customers is having ongoing trouble with a Web Service data source in CR 2011, it mostly works but will fails periodically for an unknown reason. The Web Service has been created by a third party and produces a Large amount of data, and we do not have access to it for trouble shooting purposes. I understand that third party Web Services are not supported, but that does not help our customer…

For stress testing CR 2011 I have created a simple Web Service using C# in VS 2010. When run it produces an XML like file in any web browser (IE, Firefox or Chrome) both on localhost and on another PC on the network. I plan to increase the amount of data returned until it starts to fail, hopefully.

The problem appears when I try to consume the Web Service in CR 2011, The process I am using is as follows
Browse to the XML and Web Services option in the available data sources
Select to use the Web Service Data Source
Use HTTP(S) Schema and enter the URL with WSDL on the end
No user or password is required
The Service, Port and Method are auto populated. This suggests that it can at least read the Web Service
When Finish is Selected we get “Logon failed: Details: Schema file is invalid error src-resolve: element ‘Schema@ http://www.w3…’ Not found”
.
I have tried all the options for consuming my Web Service all with the same or similar error messages.

A colleague has tried the same thing using a Java Web Service with the same results.

While I can code it is not something I do a lot of, so any help provided will need to be quite detailed.

I am slowly going bald with tearing my hair out so your help in resolving this will be appreciated…

Regards

Kevin :hb:

kbeach :new_zealand: (BOB member since 2012-03-22)

2

Hi, Kevin,
Does Crystal 2011 have a CRConfig.xml configuration file that you can inspect? My Crystal 2008 local install did not work with a web service data source until I located the CRConfig.xml file and amended several incorrect entries. The CRConfig.xml file contains an section that points to where your wsdl.xsd schema should be. Give it a shot.

Regards,

Matt P. Seltzer
mseltzer@fideliscare.org

mattyseltz (BOB member since 2009-04-27)

3

Hey, sorry for the late reply.

I found the CRConfig.xml file as you suggested, but I have no idea what should be added.

I’m guessing the which is empty, is it the web server I am using?

Thanks again for your help.

kbeach :new_zealand: (BOB member since 2012-03-22)