January 10, 2012 at 9:46 am
Hello SSRS gurus,
I'd read in one of the article that you can use parameter in your connection string; however, I have a different requirement for my report that I need help with.
I have a same table name "t_log" with same 7 fields name that appears on three different instances and three different database name (i.e. instance1.db1.t_log; instance2.db2.t_log and instance3.db3.t_log). I need to write a report that display the info in the t_log according to whatever criteria the user wants. That part of code is done; however, I don't want to create the same report three times for three instances and three databases.
I'd thought of link server, but due to our databases are not hosted by us and the hosting company decline the link server due to security. I thought of using the parameters in the connection string, and this is where I am stuck.
I'd tried this in the connection string, but where do i put the instance name ?
='Data Source='Parameters!servername.Value '; Initial Catalog=' Parameters!databasename.Value
TIA.
January 11, 2012 at 7:22 am
This was the article http://www.sqlservercentral.com/articles/Development/2945/ that I'd read about dynamic connection string.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply