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.lem
...@atosorigin.com> wrote in message
news:F64A97DB-03BE-4DE2-8112-377124D63233@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