Nrlander,

I'm using Vb.net 2008 with ODBC connection
Please i need to know how to go about Crystal Report & Dataset together, although i know how to create crystal report & dataset, but how
i'm going to generate selected data from my table to dataset in other for my crystal report to display the data as a report.

This is my code to connect my table, datast & crystal report 2geda


con.Open()
sql = "SELECT * FROM Admission"
Dim dscmd As New OdbcDataAdapter(sql, con)
Dim ds As New DataSet1
dscmd.Fill(ds, "Admission")
'MsgBox(ds.Tables(1).Rows.Count)
con.Close()
Dim objRpt As New CrystalReportSource1 'It is given error in that CrystalReportSource1, that is not declare
objRpt.SetDataSource(ds.Tables(1))
CrystalReportViewer1.ReportSource = objRpt
'CrystalReportViewer1.