水晶报表

最新推荐文章于 2024-02-07 22:09:49 发布

yygiggs

最新推荐文章于 2024-02-07 22:09:49 发布

阅读量463

点赞数

分类专栏：水晶报表文章标签：报表 dataset database string server

本文链接：https://blog.csdn.net/yygiggs/article/details/1597432

版权

水晶报表专栏收录该内容

0 篇文章 0 订阅

订阅专栏

设置dataset。xsd
SqlConnection con = new SqlConnection("server=(local);database=ddl;uid=sa;pwd=;");
        string sel = "select * from ddl2 where father='1'";
        SqlDataAdapter sda = new SqlDataAdapter(sel, con);
        con.Open();
      // DataSet1 ds = new DataSet1();
        DataSet ds = new DataSet();
        sda.Fill(ds);
        CrystalReportSource1.ReportDocument.Load(Server.MapPath("ee.rpt"));
        CrystalReportSource1.ReportDocument.SetDataSource(ds.Tables[0]);
        CrystalReportSource1.DataBind();
        CrystalReportViewer1.ReportSource = CrystalReportSource1;
        CrystalReportViewer1.DataBind();

报表select id,name,father from ddl2 where father='{?fath}'

CrystalReportSource1.ReportDocument.Load(Server.MapPath("dd.rpt"));
        CrystalReportSource1.ReportDocument.SetDatabaseLogon("sa", "", "(local)", "ddl");
        CrystalReportSource1.ReportDocument.SetParameterValue("fath", "2");
        CrystalReportSource1.DataBind();
        CrystalReportViewer1.ReportSource = CrystalReportSource1;
        CrystalReportViewer1.DataBind();*/