Datasets and Crystal Reports

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kimbred
    New Member
    • Jan 2009
    • 47

    Datasets and Crystal Reports

    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");
Working...