title: Reporting Services Connect a Report to Multiple Databases
body: <p>I have a report which I would like to have talk to different data sources on different database servers depending on some runtime parameters. Is there any way to set the report connection string on a run by run basis? I'm trying to avoid using a data processing extension but it a thin one to proxy the query seems to be the only way to do it. </p>
  
  <p><strong>Edit</strong>
  There is a feature is called expression based query strings it did not appear until the SQL server 2005 version of reporting services. <a href="http://blogs.msdn.com/b/bimusings/archive/2006/07/20/673051.aspx" rel="nofollow">http://blogs.msdn.com/b/bimusings/archive/2006/07/20/673051.aspx</a> One version too late for me. </p>