Crsytal repot Print multiple Times

See more:

ASP.NET

CrystalReports

I am facing Problem in Crystal report help me Gold hearted

I need to print information from Two tables
1.Customer Tables
2.Menu Tables,

in Visual studio i create new dataset , in designer view i add one datable and combine Two table when i load the Report its work nicely ,the problem is if a menu has 10 rows means the report will print 10 times , how to avoid it, i search all the forums , but couldn't solve the problem ( no duplication in Records , only in Pages )

This is my code...

Dim No As String = Request.QueryString("id")
      Dim con As New MySqlConnection(connectionString)
      Dim rptDoc As New ReportDocument
      Dim ds As New customerdataset
      Dim dt As New DataTable

      dt.TableName = "Crystal Report Example"
      Dim da As New MySqlDataAdapter("SELECT a.*,b.* FROM tb_customer a INNER JOIN  tb_Menu b ON a.id=b.Qno WHERE Id='" + No + "' and a.id=b.q<big></big>no Group by menu  ", con)
      da.Fill(dt)
      ds.Tables(0).Merge(dt)

      rptDoc.Load(Server.MapPath("Confirm Order.rpt"))
      rptDoc.SetDataSource(ds)
      ConfirmOrder.ReportSource = rptDoc
      rptDoc.ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, True, Page.Title)
      con.Close()
      con.Dispose()