Can I use two datasets as setdatasources to a crystalreport

Question

Dear all I am having the two different tables attached to a crystal report using Database Expert. I am getting the data from both the reports. Now in the reportviewer i am using the code like this billingreport.setdatasource(sa) CrystalReportViewer1.ReportSource = billing billinreport.setdatasource(sa2) CrystalReportViewer1.ReportSource = billing; Can i set Datasources as above? Please suggest me

Ramesh Palanivel · Answer

Hi Krishna Kumar The crystal report viewer will take the recent datasource. It will not take the two dataset. Instead of bind two datasets into single crystal report viewer use join query in table and fill it in dataset and bind the dataset to crystal report. for example find the below code DataSet ds = new DataSet(); SqlDataAdapter sdr= new SqlDataAdapter( Select table1.StuNameTable1.StuIdTable.DeptName from Table inner join Table2 on table1.DeptId=Table.DeptId con); sdr.Fill(ds); billinreport.setdatasource(sa2) CrystalReportViewer1.ReportSource = billing;