title: SSRS Report Switch Datasource
body: <p>I am using SSRS reports and now I want to change data-source base on parameter. I had all ready tried to create a dynamic data source base on parameter and it works perfect on our local environment. But on production we are not able connect database due to security issue.</p>
  
  <p>To overcome the security issue. we had created two data source "ProdDB" and "ArchDB" in reporting server and map with my report's data source</p>
  
  <p>Now I want to know how we can Switch data source base on parameter like 
  Report parameter @dbsource = "Prod"</p>
  
  <pre><code>if @dbsource.value = "Prod" then 
    datasource = "ProdDB
  Else 
    DataSource = "ArchDB"
  </code></pre>