水晶报表向参数字段传递参数

本文链接：https://blog.youkuaiyun.com/deltazxm/article/details/1437302

本文介绍如何将网页中的下拉控件与Crystal Reports报表进行数据绑定。首先创建一个下拉控件并绑定数据源；然后通过按钮触发事件加载报表，并设置连接信息；最后通过获取下拉控件的选中值作为报表参数，实现动态展示不同班级的数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

首先在页面中放入一个下拉控件并进行数据绑定。增加一个按扭控件。在点击按扭时触发事件。在事件中写入：

TableLogOnInfo deltazxm = new TableLogOnInfo();
        ReportDocument delta = new ReportDocument();
        delta.Load(Server.MapPath("../Reporters/OA_XXHMC.rpt"));
        deltazxm.ConnectionInfo.ServerName = System.Configuration.ConfigurationManager.AppSettings["ServerName"];
        deltazxm.ConnectionInfo.DatabaseName = System.Configuration.ConfigurationManager.AppSettings["Database"];
        deltazxm.ConnectionInfo.UserID = System.Configuration.ConfigurationManager.AppSettings["UID"];
        deltazxm.ConnectionInfo.Password = System.Configuration.ConfigurationManager.AppSettings["Password"];
        delta.Database.Tables[0].ApplyLogOnInfo(deltazxm);
        CrystalReportViewer1.ReportSource = delta;
        ParameterFields deltafields = new ParameterFields();
        ParameterField deltafield = new ParameterField();
        ParameterDiscreteValue deltadv = new ParameterDiscreteValue();//添加离散型参数
        ParameterRangeValue deltarv = new ParameterRangeValue();//添加区域型参数
        deltafield.Name = "班级";
        deltadv.Value = DropdownList_BJH1.SelectedValue;
        deltafield.CurrentValues.Add(deltadv);
        deltafields.Add(deltafield);
        CrystalReportViewer1.ParameterFieldInfo = deltafields;
        DataBind();