RS ADO.Net extensibility? (using a webservices as a datasource?)

Hi All,
I have to build a solution where end-users have to operate data input and
reports. (This means that the GUI must be very user friendly).
Because of this, I was thinking of using Windows Sharepoint Services (WSS)
as a front-end for data input and using Reporting Services for generating
reports on this data.
WSS will make it easy for users, because it has a real good interface for
adding columns or changing input fields. The downside is that the data in WSS
is stored in a SQL database, but it isn't very usable for an end user to get
it out of this Database (You can read why here).
So... I was thinking of building a web service that gets the information out
of WSS and presenting it in rows (record sets) for Reporting Services.
My Question:
Could the ADO.Net extensibility of Reporting Services realize that I can get
data from a webservice? And if so, can I get a recordset from a web services
and use it in the same way as querying a SQL database with RS?
I would be very happy with some help on this subject.
Any thoughts are welcome...
Grt. M.VisserYou can build custom data provider and register it in RSReportServer.config
RS exposes a lightweight version of interfaces (IDbConnection, IDbCommand,
IDataReader).
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_extend_dataproc_5c2q.asp
--
Alex Mineev
Software Design Engineer
This posting is provided "AS IS" with no warranties, and confers no rights
"Maarten Visser" <MaartenVisser@.discussions.microsoft.com> wrote in message
news:1DE68EBF-E54A-41B0-A0FB-EA8034807ACD@.microsoft.com...
> Hi All,
> I have to build a solution where end-users have to operate data input and
> reports. (This means that the GUI must be very user friendly).
> Because of this, I was thinking of using Windows Sharepoint Services (WSS)
> as a front-end for data input and using Reporting Services for generating
> reports on this data.
> WSS will make it easy for users, because it has a real good interface for
> adding columns or changing input fields. The downside is that the data in
WSS
> is stored in a SQL database, but it isn't very usable for an end user to
get
> it out of this Database (You can read why here).
> So... I was thinking of building a web service that gets the information
out
> of WSS and presenting it in rows (record sets) for Reporting Services.
> My Question:
> Could the ADO.Net extensibility of Reporting Services realize that I can
get
> data from a webservice? And if so, can I get a recordset from a web
services
> and use it in the same way as querying a SQL database with RS?
> I would be very happy with some help on this subject.
> Any thoughts are welcome...
> Grt. M.Visser
>