i have this code that reflects datagrid values in crystal reports by using datasets. i commit error "The Report Has no Tables" thx in advance
Dim report As New CrystalReport1
Dim ds As New DataSet
Try
ds.Tables.Add("Main")
Dim col As DataColumn
For Each dgvCol As DataGridViewColumn In ProductsDataGridView.Columns
col = New DataColumn(dgvCol.Name)
ds.Tables("Main").Columns.Add(col)
Next
Dim row As DataRow
Dim colcount As Integer = ProductsDataGridView.Columns.Count - 1
For i As Integer = 0 To ProductsDataGridView.Rows.Count - 1
row = ds.Tables("Main").Rows.Add
For Each column As DataGridViewColumn In ProductsDataGridView.Columns
row.Item(column.Index) = ProductsDataGridView.Rows.Item(i).Cells(column.Index).Value
Next
Next
Catch ex As Exception
MessageBox.Show("Error Converting from DataGridView" & ex.InnerException.ToString, _
"Error Converting from DataGridView", MessageBoxButtons.OK, MessageBoxIcon.Error)
End Try
report.SetDataSource(ds.Tables(0))
CrystalReportViewer1.ReportSource = report
Form2.Show()
Form2.DataGridView1.DataSource = ds.Tables(0)
ds.Dispose()
ds = Nothing