Can I use two datasets as setdatasources to a crystalreport

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.StuName,Table1.StuId,Table.DeptName from Table inner join Table2 on table1.DeptId=Table.DeptId",con);
sdr.Fill(ds);
billinreport.setdatasource(sa2)
CrystalReportViewer1.ReportSource = billing;