title: crystal report and sql command
body: <p>i have a problem in showing data content from joined table in crystal report 
  my sql query is good and it shown my own  data but i when fill crystal report  datasource and show it  the crystal repeat duplicate and more data 
  my code is:</p>
  
  <pre><code>   Dim rep As CrystalReport1 = New CrystalReport1()
      Dim objcon = New SqlConnection("data source=(local);initial catalog=hesabres;user id='sa';password='Maysam7026'")
      Dim objcom = New SqlCommand
      Dim objdata As New DataTable
      Dim objdr As SqlDataReader
      objcom.CommandText = " SELECT customer.customer_name, customer.customer_tel, orders.order_stuff_name, orders.order_number" &amp; _
  " FROM   hesabres.dbo.orders orders inner JOIN hesabres.dbo.customer customer ON orders.order_customer_id=customer.customer_id"
  
      objcom.Connection = objcon
      objcon.Open()
      objdr = objcom.ExecuteReader
      objdata.Load(objdr)
      rep.SetDataSource(objdata)
      CrystalReportViewer1.ReportSource = rep
  </code></pre>