Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swenri
Yak Posting Veteran
72 Posts |
 Posted - 2007-08-21 : 09:26:00
|
| I've a question regarding SSRS 2005. Is there an efficient scripting method to update the connection string for ALL reports that reside on a reporting/web server? "(automating the process, rather than having to change the data source for each individual report that resides on that server)". All suggestions are highly appreciated .Thanks, |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-21 : 13:37:47
|
| I worked in a reporting team few years back where we had to do a similar thing. We had a .NET guy write code to query the reporting service (its web service right) and open up the rdl files and change the data source.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
swenri
Yak Posting Veteran
72 Posts |
Posted - 2007-08-21 : 13:47:44
|
| Hi Dinakar,Could you please let me know how to do it .NET ? Thanks, |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-21 : 13:54:32
|
| I dont know what exactly he did, just an over view. If you google you can find articles that show how to query the reporting service. Perhaps that might help.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
Any alternate method available ?