Skip to Content
0
Former Member
May 03, 2012 at 10:24 PM

Problem Using multiple XML HTTP(s) Web Services

43 Views

Hello,

I'm trying to change an existing report to use SharePoint Lists. I have gotten past the first set of hurdles and can pull the XML. I can verify this in a browser.

What I'm having problems with is Crystal Reports handling of multiple web service tables. It seems to create and set the HTTP Parameters (and report Parameters) in the first XML Web Service setup. But when I go to add additional xml web services (I need 3 SharePoint Lists pulled) it uses the same Parameter Names and seems to get confused over their values.

When I run the report, it pulls data from the Oracle server, as expect, and pulls data from the "first" XML Web Service. The subsequent 2 XML Web Services are never run (blank datasets / browse data..).

As I'm having to guess; I think it's running the first Web Service data pull fine, but fails to properly handle the HTTP Parameters on the following web service calls..

Googling, I only found one reference to an issue resembling this, and it related to Crystal Reports XI and recommended SP upgrades.. ..never answered..

Any help would be appreciated, as I'm feeling stumped.. Seems like a simple enough Scenario; one report, multiple XML Web Services to the same address (owssvr.dll) with different HTTP Parameters (&List={GUID}).

How can I make this work?

Thank you in advance,

~Edward