Changing SSRS reports datasource.

I have a web site that has reports stored in two places.The local site, and in SSRS.The local reports get there data from a class that has a dataset method on it.I would like to store all my reports in SSRS.Is this possible?Can I get just the RDL of a report from the SSRS web service, or change the dataset to what my class generates?

You can adopt one to two approaches:

1) store the RDLC you'll use in a report viewer control on the report server as a resouce.

2) store actual RDL in the report server and use the GetReportDefinition method to obtain the RDL.

What is interesting here is that the data source definitions between the RDLC the control expect and the RDL that the server expects is a little different.

Here's the reference for GetReportDefinition:

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.getreportdefinition.aspx

-Lukasz

Changing DB locations in production

Can't seem to find the answer to this one.
Anyway, I have a report class that several developers use for reporting.
Each developer has his own DB.
The report class uses the web services for connecting/viewing.
What I want to do is be able for each developer to pass a connection string
or something that will point a shared report to his DB. I really don't want
to create copies of the reports.
Plus, when all production is done we may have hundreds of clients using one
report and each one would need their own DB.
Thanks for any suggestions!
cbmeeks*BUMP*
Sorry to bump but this is starting to become a problem here.
Thanks for any help!
cbmeeks
"cbmeeks" wrote:
> Can't seem to find the answer to this one.
> Anyway, I have a report class that several developers use for reporting.
> Each developer has his own DB.
> The report class uses the web services for connecting/viewing.
> What I want to do is be able for each developer to pass a connection string
> or something that will point a shared report to his DB. I really don't want
> to create copies of the reports.
> Plus, when all production is done we may have hundreds of clients using one
> report and each one would need their own DB.
> Thanks for any suggestions!
> cbmeeks