我按网上的动态加载报表的方法设置后提示缺少参数值,代码如下:
protected void Page_Load(object sender, EventArgs e)
{
string strProvider = "Server=localhost;DataBase=northwind;UID=sa;PWD=";
SqlConnection MyConn = new SqlConnection(strProvider);
MyConn.Open();
string strSel = "sp_Monthend_GoodReceive_BySKU '200708','','','A','A'"";//调用存储过程,指定了参数
SqlDataAdapter CustomerTableAdapter1 = new SqlDataAdapter(strSel, MyConn);
DataSet1 ds = new DataSet1();
CustomerTableAdapter1.Fill(ds, "Customers");
ReportDocument mycpt11 = new ReportDocument();
mycpt11.Load(Server.MapPath("mycpt.rpt"));
mycpt11.SetDataSource(ds);
this.CrystalReportViewer1.ReportSource = mycpt11;
} 最后报表却显示不出来,提示缺少参数值,我在语句里面明明给存储过程指定了参数值,DataSet中数据都已经查询出来了,最后绑定的时候为什么就不行了?
protected void Page_Load(object sender, EventArgs e)
{
string strProvider = "Server=localhost;DataBase=northwind;UID=sa;PWD=";
SqlConnection MyConn = new SqlConnection(strProvider);
MyConn.Open();
string strSel = "sp_Monthend_GoodReceive_BySKU '200708','','','A','A'"";//调用存储过程,指定了参数
SqlDataAdapter CustomerTableAdapter1 = new SqlDataAdapter(strSel, MyConn);
DataSet1 ds = new DataSet1();
CustomerTableAdapter1.Fill(ds, "Customers");
ReportDocument mycpt11 = new ReportDocument();
mycpt11.Load(Server.MapPath("mycpt.rpt"));
mycpt11.SetDataSource(ds);
this.CrystalReportViewer1.ReportSource = mycpt11;
} 最后报表却显示不出来,提示缺少参数值,我在语句里面明明给存储过程指定了参数值,DataSet中数据都已经查询出来了,最后绑定的时候为什么就不行了?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货