Web service as datasource

[Bryan Keller [MSFT]]

You would need to write a data processing extension to support this, but it
is totally doable. There is a sample dpe that ships with the product. There
are also a couple on the Web that other users have posted. If you need exact
links, I can probably hunt them down.

--
Bryan Keller
Developer Documentation
SQL Server Reporting Services

A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.

"Darren Osborne" <osbo...@qsa.co.uk> wrote in message
news:%23omkbS9...@tk2msftngp13.phx.gbl...
> Can I use a web service that returns a dataset as my data source?
> Anyone have any examples / documentation to help me?
>
> Thanks
>
>

[Bryan Keller [MSFT]]

[Darren Osborne]

Thanks Bryan,

I've looked at the sample app, and i get the gist.

If you can point me towards any more examples, I would be greatful.

"Bryan Keller [MSFT]" <bry...@online.microsoft.com> wrote in message
news:Oqw8lDk%23DHA...@TK2MSFTNGP09.phx.gbl...

[Bryan Keller [MSFT]]

We don't have an example right now. Maybe you could write one? :) I'm only
half joking because a good sample of this is what a lot of customers are
looking for. You would make yourself quite popular.

It wouldn't be hard to do, if your Web service returned a data set or some
other data structure that was understood by the report server (columns and
rows), then you could plug your Web service in no problem. The sample that
comes with the product as well as the documentation should get you started.

--
Bryan Keller
Developer Documentation
SQL Server Reporting Services

A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.

"Pjotr" <peter....@atosorigin.com> wrote in message
news:F64A97DB-03BE-4DE2...@microsoft.com...
> Bryan,
>
> I would also like to know more about using an webservice (returning an
.NET Dataset) as source for an report. We currently cannot use Reporting
Services in the production environment because the company standard only
alows web-applications to connect to a database via a separate
business-logic tier. This is for security reasons. They don't like the fact
that database security credentials are stored on a web-server.
>
> If i could use a webservice as datasource for my reports then i could let
them call into the business layer.
>
> If you have any example available i would be very thankfull.
>
> Peter

[Rohan Cragg]

It's been done now, see my blog for details:

http://www.sharepointblogs.com/rcragg/archive/2004/06/11/540.aspx
Rohan