title: reporting services in vb.net - report viewer
body: <p>I havea report viewer on my frmReports. I've created 2 reports, Report1.rdlc and Report2.rdlc. I have a strongly defined DataSet - with two DataTables (1, 2) for each report respectively. I'm trying to be able to use that same reportViewer in displaying both reports. </p>
  
  <p>Currently I have two buttons (1 for each report) so that on button click - I query against SQL SERVER to get data and load it into each DataTable like this..</p>
  
  <pre><code>    adapter = New SqlDataAdapter(sql, Con)
      adapter.Fill(ds)
  
      ds.Tables(0).TableName = "DataTable1"
      ReportViewer1.LocalReport.ReportEmbeddedResource = "WindowsApplication1.Report1.rdlc"
      DataTable1BindingSource.DataSource = ds
      ReportViewer1.RefreshReport()
  </code></pre>
  
  <p>I do the same thing for Report2 but with DataTable2 and I change EmbededResource to Report2 and DataTable Binding to DataTable2.</p>
  
  <p>The thing is, one of the report has to be pre-selected in CHOOSE REPORT before I run my application - so if Report1.rdlc is preselected - then when I debug it and run Report1 it runs perfectly fine. However, when it's not letting me run Report2 in that case.</p>
  
  <p>I've tried using these two functions on Form_Load (in that case the report viewer is empty and should only be populated if user clicks on any one of the buttons.</p>
  
  <pre><code>ReportViewer1.Reset()
  ReportViewer1.LocalReport.DataSources.Clear()
  </code></pre>
  
  <p>but it tells me that </p>
  
  <blockquote>
    <p>Data source instance has not been supplied for data source DataSet1.</p>
  </blockquote>