Dynamic Connection for mulitiple parameters in Reporting Services

• amit.sinha-717308

  SSC-Addicted

  Points: 408

  More actions

  July 15, 2008 at 5:08 am

  #381669

  Hi,

  I am using following connection string to connect to multi server and databases:

  ="data source=" & Parameters!Server.Value & ";initial catalog=" & Parameters!Database.Value

  It works fine for single parameter, however when I change other parameters to use dynamic connection it throws an error.

  Any help will be greatly appreciated.

• Hari.Sharma

  SSCertifiable

  Points: 6904

  More actions

  July 15, 2008 at 6:24 am

  #843012

  Hi Amit,

  go throug this link:

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

  Cheers,
  Hari
  Tips & Tricks for SQL BI Developers