[VB.NET]Open in popup window
Private Sub CreateReport(ByVal ReportPath As String)
Dim report As New DevExpress.XtraReports.UI.XtraReport()
report.LoadLayout(ReportPath)
Dim reportDataSet As DataSet = TryCast(report.DataSource, DataSet)
Dim newDataSet As New DataSet(reportDataSet.DataSetName)
For Each dt As DataTable In reportDataSet.Tables()
Dim newDataTable As DataTable = LoadDataTable(dt.TableName())
newDataSet.Tables.Add(newDataTable)
Next
report.DataSource = newDataSet
PrintControl1.PrintingSystem = report.PrintingSystem
report.PrintingSystem.SetCommandVisibility(DevExpress.XtraPrinting.PrintingSystemCommand.Parameters, DevExpress.XtraPrinting.CommandVisibility.None)
report.CreateDocument(True)
End Sub
Private Function LoadDataTable(ByVal tableName As String) As DataTable
Dim cmd As New OleDb.OleDbCommand("SELECT * FROM " & tableName, conn)
Dim dt As New DataTable(tableName)
conn.Open()
dt.Load(cmd.ExecuteReader)
conn.Close()
Return dt
End Function