I have a Crystal Report that requires several tables from a dataset to complete. The data from the first two sources seem to work fine but the data from the third doesn't seem to show up. I'm needing to know if I'm filling the datasets correctly based on the code below.
r = new CrystalReportSo urce();
r.ReportDocumen t.Load(MapPath( "~/SelfService/Controls/PayStub.rpt"));
SelfServiceData Set sds = new SelfServiceData Set();
sds = Intranet.BLL.Se lfServiceMain.P rovider.GetStub Detail(Convert. ToInt32(Session["Chkctl"]));
SelfServiceData Set dds = new SelfServiceData Set();
dds = Intranet.BLL.Se lfServiceMain.P rovider.GetDepo sitInfo(Profile .Employees.EmpI d, Convert.ToInt32 (Session["Chkctl"]));
DataRow nr = sds.Employee.Ne wRow();
nr["Name"] = Session["EmpName"]; ;
nr["Address"] = Profile.Employe es.Address1;
nr["CityStZip"] = Profile.Employe es.City + ", " + Profile.Employe es.State + " " + Profile.Employe es.Zip;
nr["EmpId"] = Profile.Employe es.EmpId;
if (Session["Company"].ToString() == "00010")
nr["Company"] = "Rural Telephone Service Co.";
else
nr["Company"] = "Nex-Tech Wireless";
sds.Employee.Ro ws.Add(nr);
sds.Deposits.Ro ws.Add(dds);
r.ReportDocumen t.SetDataSource (sds);
r.ReportDocumen t.ExportToHttpR esponse(Crystal Decisions.Share d.ExportFormatT ype.PortableDoc Format,
Response, false, "PayStub.pd f");
r = new CrystalReportSo urce();
r.ReportDocumen t.Load(MapPath( "~/SelfService/Controls/PayStub.rpt"));
SelfServiceData Set sds = new SelfServiceData Set();
sds = Intranet.BLL.Se lfServiceMain.P rovider.GetStub Detail(Convert. ToInt32(Session["Chkctl"]));
SelfServiceData Set dds = new SelfServiceData Set();
dds = Intranet.BLL.Se lfServiceMain.P rovider.GetDepo sitInfo(Profile .Employees.EmpI d, Convert.ToInt32 (Session["Chkctl"]));
DataRow nr = sds.Employee.Ne wRow();
nr["Name"] = Session["EmpName"]; ;
nr["Address"] = Profile.Employe es.Address1;
nr["CityStZip"] = Profile.Employe es.City + ", " + Profile.Employe es.State + " " + Profile.Employe es.Zip;
nr["EmpId"] = Profile.Employe es.EmpId;
if (Session["Company"].ToString() == "00010")
nr["Company"] = "Rural Telephone Service Co.";
else
nr["Company"] = "Nex-Tech Wireless";
sds.Employee.Ro ws.Add(nr);
sds.Deposits.Ro ws.Add(dds);
r.ReportDocumen t.SetDataSource (sds);
r.ReportDocumen t.ExportToHttpR esponse(Crystal Decisions.Share d.ExportFormatT ype.PortableDoc Format,
Response, false, "PayStub.pd f");