title: SSRS reports with multiple database
body: <p>I am creating an SSRS report which will fetch data from two different databases. The problem is that, the database names will be different in development and live servers.</p>
  
  <p>My question is -
  1) What should I do at Stored Proc level so that I don't need to change anything there if the database name gets changed?
  2) What should I do at report level (or on dataset) so that I don't need to change anything for the different database names?</p>
  
  <p>I am having SSRS deployed on SQL Server 2008 R2.</p>