title: Crystal reports not showing records returned by sql query
body: <p>I am using crystal reports to print invoice.</p>
  
  <p>it consist of fields from multiple tables.</p>
  
  <p>I have created oledbcommand, Oledbdataadapter and dataset to display results in crystal report.</p>
  
  <p>Problem:</p>
  
  <p>If I put details of Customer in "Page header" section of crystal report it only shows the first record</p>
  
  <p>and if I put them in "Details" section of crystal report it shows all the records.</p>
  
  <p>I have varified the data returned by sql query by showing the result in a datagrid, there the data returned is correct.</p>
  
  <p>So please someone help me with this issue.</p>
  
  <p>P.S. : I am using Ms Access database.</p>
  
  <p>and I have only a little knoledge of crystal report so I might have made a silly mistake.</p>
  
  <p>If possible please upload the whole code to print multiple database tables onto a crystal report.</p>
  
  <p>I'm really STUCK so please HELP</p>
  
  <p>Code:</p>
  
  <pre><code>bcmd = New OleDbCommand
  bcmd.Connection = Functions.dbcon
  bcmd.CommandText = "SELECT * from Item where Item_ID = 16"
  bcmd.ExecuteNonQuery()
  
  bda = New OleDbDataAdapter(bcmd)
  bds = New DataSet
  
  bda.Fill(bds)
  
  rptdoc.load("full absolute path")  // file exists here , so no issues with it 
  
  rptdoc.setdatasource(bds.tables(0))
  
  repview.reportsource = rptdoc
  </code></pre>