I wanted to ask if anyone else has found a problem with rs.exe when trying to use the SetReportDataSources method.
The line appears as RS.SetReportDataSources(fullpath, dataSources)
The error is BC30456 - 'SetReportDataSorces' is not a member of 'Microsoft.SqlServer.ReportingServices2005.ReportingService2005'.
The aim is to design a single set of reports, that will be deployed to different folders with a different datasource per folder. Each datasource connects to an cube that is set up on a database of client data. There is therefore one database and one cube per client, and all databases and cubes have the same structure. This is being done to allow outside clients to view their own reports without being able to see other clients data.
Anyone else have a similar problem and fixed it, or could offer any hints?
Many thanks - Leo.
In SQL 2005, the name of this method is now called 'SetItemDataSources'. If you want to use the SQL 2000 RS endpoint, you need to run rs.exe with the -e option.
No comments:
Post a Comment