Reporting Services

• Erin.

  SSCertifiable

  Points: 5237

  More actions

  November 24, 2008 at 9:27 am

  #203302

  I need to create a report that will allow the user to run the report against two different servers. Can I setup two different data sources that the user can choose? I was thinking a drop down of the two servers. Is this possible without pulling the data from both servers into one central place?

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  November 24, 2008 at 12:49 pm

  #902701

  Search google for "ssrs dynamic connection string".

  You can build the connection string from parameter information. There are some pretty clear examples if you look around a bit.