title: Not able to bind crystal report properly when using dataset, showing parameters missing
body: <p>I have crystal report which is working fine when I use <code>DSN</code> as a datasource. 
  Problem is I am using dataset now. Dataset contains all the table I need and I am populating it with data from database using Stored procedure. 
  But, in this way, it is throwing an error : "<code>Missing Parameters</code>". </p>
  
  <p>I am doing as below :<br>
  <strong>Step 1</strong> : Creating <code>Dataset1.xsd</code> and using <code>data connections</code> inserting all required <code>tables</code> from database in it.<br>
  <strong>Step 2</strong> :Giving <code>data source</code> to report using <code>database expert</code> as <code>Dataset1.xsd</code><br>
  <strong>Step 3</strong> : Populating data using Stored procedure in data set and then creating instance of <code>Dataset1</code> and merging data from data set to <code>Dataset 1</code> instance.</p>
  
  <p>My code to fetch data from database and then merge that to <code>Dataset1</code> instance and giving that as source to crystal report is as below : </p>
  
  <pre><code>Private Sub ReportByDataset(ByVal rptDoc As CrystalDecisions.CrystalReports.Engine.ReportDocument)
  
      'new code
  
      Dim myConnection As New SqlClient.SqlConnection()
      'myConnection.ConnectionString = "server= (local)\NetSDK;database=pubs;Trusted_Connection=yes"
      Dim ds As New DataSet1
  
      myConnection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings("HighriseContractingWebConnectionString").ConnectionString
      myConnection.Open()
      Dim MyCommand As New SqlClient.SqlCommand()
      MyCommand.Connection = myConnection
  
      MyCommand.CommandText = "SP_Web_GetReportTables"
      MyCommand.CommandType = CommandType.StoredProcedure
      Dim MyDA As New SqlClient.SqlDataAdapter()
      MyDA.SelectCommand = MyCommand
      Dim myDS As New DataSet
  
      MyDA.Fill(myDS)
      myConnection.Close()
  
  
      ds.Tables("RABill_RPT").Merge(myDS.Tables(0), MissingSchemaAction.Ignore)
      myDS.Tables(0).Reset()
      ds.Tables("RA_bills").Merge(myDS.Tables(1), MissingSchemaAction.Ignore)
      ds.Tables("Work_Completion").Merge(myDS.Tables(2), MissingSchemaAction.Ignore)
      ds.Tables("contractor").Merge(myDS.Tables(3), MissingSchemaAction.Ignore)
      ds.Tables("WO_Header").Merge(myDS.Tables(4), MissingSchemaAction.Ignore)
      ds.Tables("Project").Merge(myDS.Tables(5), MissingSchemaAction.Ignore)
      ds.Tables("contractor_1").Merge(myDS.Tables(6), MissingSchemaAction.Ignore)
      ds.Tables("Users").Merge(myDS.Tables(7), MissingSchemaAction.Ignore)
      ds.Tables("Users_Approved").Merge(myDS.Tables(8), MissingSchemaAction.Ignore)
      ds.Tables("voucher").Merge(myDS.Tables(9), MissingSchemaAction.Ignore)
      ds.Tables("Employee_Approve").Merge(myDS.Tables(10), MissingSchemaAction.Ignore)
      ds.Tables("Employee").Merge(myDS.Tables(11), MissingSchemaAction.Ignore)
      ds.Tables("Account").Merge(myDS.Tables(12), MissingSchemaAction.Ignore)
      ds.Tables("TDS").Merge(myDS.Tables(13), MissingSchemaAction.Ignore)
      ds.Tables("WO_Detail").Merge(myDS.Tables(14), MissingSchemaAction.Ignore)
      ds.Tables("V_WO_BlockTaskNo").Merge(myDS.Tables(15), MissingSchemaAction.Ignore)
      ds.Tables("TASK").Merge(myDS.Tables(16), MissingSchemaAction.Ignore)
      ds.Tables("Cont_Voucher").Merge(myDS.Tables(17), MissingSchemaAction.Ignore)
      ds.Tables("Cont_Voucher_1").Merge(myDS.Tables(17), MissingSchemaAction.Ignore)
      ds.Tables("Cont_Voucher_2").Merge(myDS.Tables(17), MissingSchemaAction.Ignore)
      ds.Tables("Company").Merge(myDS.Tables(18), MissingSchemaAction.Ignore)
  
  
      ''new code ends
  
  
      rptDoc.SetDataSource(ds)
      CRReport.HasCrystalLogo = False
      CRReport.HasToggleGroupTreeButton = False
      CRReport.ReportSource = rptDoc
      CRReport.DataBind()
  
  End Sub
  </code></pre>
  
  <p>But it is not working, what am I missing. Same works fine using <code>DSN</code>  It is not problem of parameters and same is working fine other way.<br>
  <strong>Note: I know above code is not memory optimised, but my concern for now is to somehow make it work, I can later optimise it</strong> </p>
  
  <p>Below image shows Dataset1 as datasource<br>
  <img src="https://i.stack.imgur.com/JfbWB.png" alt="enter image description here"></p>