External web service as datasource for Reporting Service report

Hello,
I would like to make some Reporting Services reports from a datasource
that is a web service. Is this possible? I am using SSRS 2005. Any
suggestions or directions would be greatly appreciated.
photogulliverIt is possible but I haven't done it. Read up in Books On Line on XML.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/d23408e5-e65b-4f49-a98f-234454d5d267.htm
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<ehausig@.yahoo.com> wrote in message
news:1141931933.379723.119120@.e56g2000cwe.googlegroups.com...
> Hello,
> I would like to make some Reporting Services reports from a datasource
> that is a web service. Is this possible? I am using SSRS 2005. Any
> suggestions or directions would be greatly appreciated.
> photogulliver
>|||Yes. it is possible.
however, there are serious limitations on this approach. see other
postings in this group by me and Teo's responses to my postings.
1. the XML returned by the web service may not be readily consumable by
SSRS.
2. the query syntax to consume the XML is xpath like, but it is neither
xpath not xquery
3. security is a big concern. webservices consumption is non-secure
however, you can write your own custom data processing extension which
can overcome the above limitations.
thanks
- jasthi|||Ok, thanks for the feedback!
Eric