SSRS - Retrieving XML data from a web service/calling web service from report problems...

SSRS - Retrieving XML data from a web service/calling web service from report problems...

Post by Jay » Sun, 20 May 2007 03:12:21


OK I've been trying to both make my own example, as well as, get the
Microsoft examples located here to work:

http://www.yqcomputer.com/

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/d23408e5-e65b-4f49-
a98f-234454d5d267.htm

I just want the report to call a web service and bring back data.

For the Microsoft example, I follow it exactly and get 'Failed to
execute web request for specified URL / Server did not recognize the
value of HTTP Header SOAPAction:
http://www.yqcomputer.com/ '

For my example, I try to mimmick/mirror the way the Microsoft example
demonstrates, but with my web service (which takes a string and an int
and returns an XML string) I can actually debug into the web service,
but always my passing parameters wind up null at the beginning of the
webmethod.

Can someone point me in the right direction please? Are there other,
working examples of reports calling web services out there? Is there
something else I'm doing wrong?

Thank you...
 
 
 

SSRS - Retrieving XML data from a web service/calling web service from report problems...

Post by SleepyLa » Tue, 22 May 2007 12:26:32


Try passing both parameters as strings, and let the web service cast
the second one back to an integer.

I was having the exact same symptom - but with a string and date
parameters - when I re-wrote the webservice to expect a string instead
of a date ( and the casting it to date using CDATE(value) ) it all
worked fine.

 
 
 

SSRS - Retrieving XML data from a web service/calling web service from report problems...

Post by Lisa Slate » Tue, 22 May 2007 14:16:11

>>
<<

Something is fishy. I see that the article you cite was revised in May
2007. Yet, when I look at my reportserver directory, I see this in the WSDL
(and it's a fairly new install, plus I just applied the BOL patch but this
file was not touched in the patch AFAICS) :

targetNamespace=" http://www.yqcomputer.com/ "

I bet you will see the same thing if you check http://<your
server>/ReportServer/ReportService2005.asmx and look at the WSDL for the
management web service. If you use the one that the server expects, maybe
the example you're following will work as advertised.

As far as what happens when you access your own SOAP service and why your
parameters don't get passed... I'm not going to guess that without some more
information... <g>

But where and how did you build your own web service? Usually there is some
problem of recognizing or translating the types properly, but it's difficult
to say "in mid air".