title: Dynamically change the connection of a Crystal Report
body: <p>I am using CrystalReportViewer and CrystalReportSource to load and display an .rpt file in my application.</p>
  
  <p>The situation I have is this:</p>
  
  <p>Say a person created a crystal report outside of my application and set its datasource to database A.  I then use that .rpt file in my application but I need to bind it to a different database (identical to the original one in terms of table structure and column names but with a different connection string using a different user name and password).  How do I do that in C#?</p>
  
  <p>Currently I load the report using:</p>
  
  <pre><code>this.CrystalReportSource1.ReportDocument.Load(reportsSubfolder + report.ReportFileName);
  //it is here that I need to change the connection data of the report.
  </code></pre>