CODEWITHSUNDEEP
sql-serverreporting-services
bhavna dubey
bhavna dubey

Reputation: 1

Set DSN for all reports

I have a Report folder on Report server and this folder have 73 reports. I have created the shared data source (DSN). Now, I want to change the data source of all reports in one go. Is there any option to set common dsn for all report?

I have right click on report and selected manage tab. After that in property window I have set the data source and its done successfully,

But doing same way for all report will take more time, so I want any shortcut for that.

Upvotes: 0

Views: 151

Answers (1)

Greg Low
Greg Low

Reputation: 1586

Unfortunately no. SSRS has very few bulk operations like that. The reports though, are just XML (called RDL). One option would be to modify one, find out the change that was made, and to write a small program to update all the reports.

Upvotes: 0

Related Questions