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" <osbor...@qsa.co.uk> wrote in message
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" <osbor...@qsa.co.uk> wrote in message
> 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.
> A friendly reminder that this posting is provided "AS IS" with no > warranties, and confers no rights.
> "Darren Osborne" <osbor...@qsa.co.uk> wrote in message > news:%23omkbS99DHA.1128@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?
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
> 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
|
