Configurable connection string in SSRS

[siddisagar]

Hi Frds, I want to pass connection string parameters in SSRS side. How to do this? Actually I am using connection info in SSRS side but if I want to promote my reports to production then how can I make connection string configurable in SSRS Thanks,

[Mycroft Holmes]

We set the server name up as an expression variable and then use the variable in the connection within SSRS, works and allows the user to select the server to run against but makes supporting the report difficult.

Never underestimate the power of human stupidity RAH