Collapse | http://www.codeproject.com/Questions/772444/How-do-I-display-two-different-query-results-in-tw# - Copy Code

//CrystalReport1 is main where I want to show subreport
//CrystalReport4 is subreport

CrystalReport1 ObjRpt;
 
CrystalReport4 ObjRpt1;
 
ObjRpt = new CrystalReport1();
 
ObjRpt1 = new CrystalReport4();
 
String StrQuery;
 
StrQuery="SELECT Id,Name,MemberRank FROM Members WHERE Cat=1";
 
OleDbDataAdapter adp = new OleDbDataAdapter(StrQuery.ToString(), ControlRules.ClsConnect.Conn);
 
                DataSet ds = new DataSet();
 
                int ctr = adp.Fill(ds);
 
                DataSet1 Ds = new DataSet1();
 
                adp.Fill(Ds, "Customer");
 
StrQuery="SELECT Id,Name,SubRank,Ratiopergrop,NHPL,((KLP_Num * 120) - 25) as "RHN_Number" FROM Members WHERE Cat=2";
 
               OleDbDataAdapter adp1 = new OleDbDataAdapter(result1.ToString(), ControlRules.ClsConnect.Conn);
 
                DataSet ds1 = new DataSet();
 
                int ctr1 = adp1.Fill(ds1);
 
                ds1.Tables[0].Rows.Add(0, "", 0, 0, 0, 0);
 
                DataSet6 Ds1 = new DataSet6();
 
                adp1.Fill(Ds1, "Customer1");
 
                ObjRpt1.SetDataSource(Ds1);
 
                ObjRpt.SetDataSource(Ds);
 
                ReportDocument crystalReport = new ReportDocument();
 
                ReportDocument crystalReport1 = new ReportDocument();
 
                crystalReport=ObjRpt;
 
                crystalReport1 = ObjRpt1;
 
crystalReportViewer1.ReportSource = ObjRpt;