首先在页面中放入一个下拉控件并进行数据绑定。增加一个按扭控件。在点击按扭时触发事件。在事件中写入:
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();
这样就可以把下接控件中的值传递给报表字段(这里的参数字段是"班级")
在报表中也需要对参数字段做少量的配置。在这里就不介绍了。