my problem is i know how to retrive a data from single table and bind it to crystal report and using crystal report viewer i can directly print it using directly button clicking on my form
but i have problem that is how can i retrive a data from more than one table and used it..
for single table the code is as follow:
On Button click event:
Call openconnection()
str = "SELECT * from New_Case_Id_Master where CaseId=" & s_no & ""
da = New SqlDataAdapter(str, cn)
ds.Clear()
da.Fill(ds, "New_Case_Id_Master")
cn.Close()
Dim objRpt As New CrystalReport_for_FrontDesk
objRpt.SetDataSource(ds.Tables("New_Case_Id_Master"))
CrystalReportViewer1.ReportSource = objRpt
CrystalReportViewer1.PrintReport()
CrystalReportViewer1.PrintReport()
CrystalReportViewer1.Refresh()
my question is how can i modify this code for retrieving data from multiple tables..