ssrs question

• rpatil22

  Ten Centuries

  Points: 1371

  More actions

  April 14, 2010 at 2:34 pm

  #221329

  I will pass server name as parameter in report.

  then how to configure report connection to take that servername and run the query against it?

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  April 15, 2010 at 4:50 am

  #1152003

  Good question,

  What I understand is as below:

  I would have have created a linked server (Server Object) and use a fully qualified name to execute my dynamic SQL query.

  Raunak J