sql server reporting services: Reporting Services Consume A Web Service -- sql server reporting services

Reporting Services Consume A Web Service

Chris
12/9/2005 12:27:19 PM

sql server reporting services: 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

Re: Reporting Services Consume A Web Service

siva.jasthi NO[at]SPAM gmail.com
12/10/2005 7:44:37 AM

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

[quoted text, click to view]

Re: Reporting Services Consume A Web Service

Teo Lachev [MVP]
12/12/2005 8:11:54 AM

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/

-------------------------------------------------
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.