Private Sub cmdReport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdReport.Click
'REPORT OBJECT
Dim MyRpt As New CrystalReport1
'DATASET, AND DATAROW OBJECTS NEEDED TO MAKE THE DATA SOURCE
Dim row As DataRow = Nothing
Dim DS As New DataSet
'ADD A TABLE TO THE DATASET
DS.Tables.Add("ListViewData")
'ADD THE COLUMNS TO THE TABLE
With DS.Tables(0).Columns
.Add("Field1", Type.GetType("System.String"))
.Add("Field2", Type.GetType("System.String"))
.Add("Field3", Type.GetType("System.String"))
End With
'LOOP THE LISTVIEW AND ADD A ROW TO THE TABLE FOR EACH LISTVIEWITEM
For Each LVI As ListViewItem In ListView1.Items
row = DS.Tables(0).NewRow
row(0) = LVI.SubItems(0).Text
row(1) = LVI.SubItems(1).Text
row(2) = LVI.SubItems(2).Text
DS.Tables(0).Rows.Add(row)
Next
'SET THE REPORT SOURCE TO THE DATABASE
MyRpt.SetDataSource(DS)
'ASSIGN THE REPORT TO THE CRVIEWER CONTROL
CRViewer.ReportSource = MyRpt
'DISPOSE OF THE DATASET
DS.Dispose()
DS = Nothing
End Sub
please help me with this mine couldn't execute maybe bcoz of the crystal reports please teach the step on how you make your crystal reports
ReplyDelete