SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Reporting Services Development
 Automatically connect to new data source in SSRS 2
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Roz
Starting Member

USA
6 Posts

Posted - 04/14/2013 :  16:56:02  Show Profile  Reply with Quote
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

India
52309 Posts

Posted - 04/15/2013 :  02:28:40  Show Profile  Reply with Quote
you can use an expression for your datasource

see

http://www.sqlservercentral.com/articles/Development/2945/

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Roz
Starting Member

USA
6 Posts

Posted - 04/15/2013 :  19:22:41  Show Profile  Reply with Quote
Hi Vishak,

Thanks for the reply.

But I couldn't find the option "Report Parameters" in SSRS 2008.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 04/16/2013 :  02:26:01  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Roz
Starting Member

USA
6 Posts

Posted - 04/16/2013 :  21:34:30  Show Profile  Reply with Quote
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.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 04/17/2013 :  01:03:55  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Roz
Starting Member

USA
6 Posts

Posted - 04/17/2013 :  23:11:51  Show Profile  Reply with Quote
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.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 04/18/2013 :  03:55:54  Show Profile  Reply with Quote
the expression should be set at report building time. value for parameters can be passed through url at runtime.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Roz
Starting Member

USA
6 Posts

Posted - 04/18/2013 :  20:18:33  Show Profile  Reply with Quote
I didn't get it. If you don't mind, can you explain little bit more?


Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 04/19/2013 :  02:44:54  Show Profile  Reply with Quote
check the link i posted earlier. it has screenshots explaining this

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Roz
Starting Member

USA
6 Posts

Posted - 04/19/2013 :  20:08:33  Show Profile  Reply with Quote
Thanks Vishak
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000