存储过程做水晶报表的数据源,参数传不进去
具体代码:
ParameterValues pvs1 = new ParameterValues();
ParameterDiscreteValue pdv1 = new ParameterDiscreteValue();
ReportDocument rptDu = new ReportDocument();
ParameterValues pvs2 = new ParameterValues();
ParameterDiscreteValue pdv2 = new ParameterDiscreteValue();
rptDu.Load(Server.MapPath(".\\Crpt\\") + "CrystalReport2.rpt");
pdv1.Value = Request.QueryString["DepartmentID"].ToString();
pvs1.Add(pdv1);
rptDu.DataDefinition.ParameterFields["@DepartmentID"].ApplyCurrentValues(pvs1);
pdv2.Value = Request.QueryString["Month"].ToString();
pvs2.Add(pdv2);
rptDu.DataDefinition.ParameterFields["@Month"].ApplyCurrentValues(pvs2);
CrystalReportViewer1.ReportSource = rptDu;