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()
Go to the Section Expert > Select the Details Section > Paging tab > click the formula button beside 'End of Section' under 'New Page After' and use this code: PageNumber = 0 AND RecordNumber = 5
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)