| Author |
Topic |
|
Roz
Starting Member
6 Posts |
 Posted - 2013-04-14 : 16:56:02
|
| Hi,I have lots of reports(as different projects) created using the version SSRS 2008 and the Data Source is ORACLE. All the reports are connected to one DB server. But soon DB sever is going to change. So whenever there is a change in the db server I want all the reports to be automatically connected to that new server. So I don't need to individually change the data source of all the reports manually. Please help me to find a solution to this problem.Thanks in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
Roz
Starting Member
6 Posts |
Posted - 2013-04-15 : 19:22:41
|
| Hi Vishak,Thanks for the reply.But I couldn't find the option "Report Parameters" in SSRS 2008. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-16 : 02:26:01
|
| hmm... you can find it by selecting View-> ReportData from top menu. Then in ReportData window right click on Parameters folder and select Add Parameter to get parameter properties window------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Roz
Starting Member
6 Posts |
Posted - 2013-04-16 : 21:34:30
|
Hi Vishak,I am new to SSRS. And I haven't used SSRS 2005. I knew about the parameters in reports. But when I saw the screen print in the link, I felt like it is completely different. So now I think it will work. But I found another method which is so simple and you might know about it. Data source of all deployed reports can be changed in the report manager which I never knew. Thank you so much for your help.  |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-17 : 01:03:55
|
| yep...report manager you can change datasource. But that again is static and everytime you want a change you need to open report properties and do it in report manager.My suggested method doent require user intervention like that as the data source properties will get value from parameters at runtime------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Roz
Starting Member
6 Posts |
Posted - 2013-04-17 : 23:11:51
|
| But the issue is that all of them receiving the reports don't have access to the SSRS link. Reports are scheduled and send in the PDF format. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-18 : 03:55:54
|
| the expression should be set at report building time. value for parameters can be passed through url at runtime.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Roz
Starting Member
6 Posts |
Posted - 2013-04-18 : 20:18:33
|
| I didn't get it. If you don't mind, can you explain little bit more? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-19 : 02:44:54
|
| check the link i posted earlier. it has screenshots explaining this------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Roz
Starting Member
6 Posts |
Posted - 2013-04-19 : 20:08:33
|
| Thanks Vishak |
|
|
|
|
Automatically connect to new data source in SSRS 2