February 6, 2009 at 12:59 pm
Basically I'm wondering if there is a way to change ALL of the reports in SQL server reporting services
to use a shared data source.
Basically these reports were imported from Microsoft Access, and I need to point them ALL to a database
that now lives in SQL server.
Any Help would be appreciated!
Thanks,
Nate
February 7, 2009 at 5:18 am
You can change the data source that the reports are mapped to within Report Manager by going into the properties of the report within Report Manager and going into the data sources section within the reports properties. If you have the shared data source deployed then you can browse for that data source or you can go ahead and create the data source within Report Manager first as long as you have the necessary permissions to do so.
The other option would be to change the data source for each report in the project and then redeploy them. If you don't have them in this format you could use the RS Scripter tool to pull them down and get all of the RDL.
If you have the shared data source created in Report Manager you could look at possibly just updating the datasource table in the ReportServer database for each report itemid and point them to the new data source. Just make sure that in doing this that you filter the itemids for the itemids in the catalog with a Type value of 2 (DataSource = 5, Folder = 1, LinkedReport = 4, Report = 2, Resource = 3, Report Model = 6, Unknown = 0).
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply