title: How to create dynamic connection string for Crystal Report in Asp.Net C# in my case?
body: <p>I have multiple iis, all the iis webpages are connecting with different database. I have too many Crystal Reports, once I upload it to all multiple iis, it has to connect to that corresponding database.</p>
  
  <p>I don't have any idea to make connection string in crystal report.</p>
  
  <p>Here is my ReportViewer code</p>
  
  <pre><code>protected void CrystalReportViewer1_Init(object sender, EventArgs e)
      {
          ReportDocument _rdStudents = new ReportDocument();
  
          Trace.Write("/CrystalReportFiles/RMS/Inventory/");
          string reportPath = Server.MapPath("~" + Request.QueryString["filename"].ToString());
  
          _rdStudents.Load(reportPath);
          CrystalReportViewer1.ReportSource = _rdStudents;
      }
  </code></pre>
  
  <p>How can i make connection string here. I saw some of this <a href="https://forums.asp.net/t/1494220.aspx?Dynamically%20setting%20connection%20string%20to%20a%20report" rel="nofollow noreferrer">link</a>. But I didn't get the point.</p>