Reporting Services Consume A Web Service

Is it possible to have a Reporting Services consume a web service that
generates a dataset, then turn around and generate the report based on
that dataset? I'm using SQL Server 2000. I'm trying to implement a
middle web service based tier and would like to prevent reporting
services from interacting directly with my application databases. Any
pointers would be greatly appreciated.
thx - ChrisI think with SSRS 2000, you will have to write a custom data processing
extension.
With SSRS 2005 version, you can use the web services as a data source
and SOAP methods within the webservice as the data sets.
See http://msdn2.microsoft.com/en-us/library/ms345334.aspx for more
details.
thanks
- jasthi
Chris wrote:
> Is it possible to have a Reporting Services consume a web service that
> generates a dataset, then turn around and generate the report based on
> that dataset? I'm using SQL Server 2000. I'm trying to implement a
> middle web service based tier and would like to prevent reporting
> services from interacting directly with my application databases. Any
> pointers would be greatly appreciated.
> thx - Chris|||Correct, with RS 2000 you need to write a custom data extension. With RS
2005, consider the XML data provider.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
<siva.jasthi@.gmail.com> wrote in message
news:1134229477.755572.183070@.f14g2000cwb.googlegroups.com...
>I think with SSRS 2000, you will have to write a custom data processing
> extension.
> With SSRS 2005 version, you can use the web services as a data source
> and SOAP methods within the webservice as the data sets.
> See http://msdn2.microsoft.com/en-us/library/ms345334.aspx for more
> details.
> thanks
> - jasthi
>
> Chris wrote:
>> Is it possible to have a Reporting Services consume a web service that
>> generates a dataset, then turn around and generate the report based on
>> that dataset? I'm using SQL Server 2000. I'm trying to implement a
>> middle web service based tier and would like to prevent reporting
>> services from interacting directly with my application databases. Any
>> pointers would be greatly appreciated.
>> thx - Chris
>