报告服务2005 c#报告查看器路径中的非法字符
本文关键字:报告 非法 字符 路径 服务 2005 | 更新日期: 2023-09-27 18:08:31
我有一个在VS2010中设计的报告服务报告。当使用"前端"报表查看器和sqldatasource时,报表运行良好。然而,我正试图通过"背后的代码"改变报告的数据源和参数。当我运行相同的报告时,它会抛出这个错误"路径中的非法字符"。到目前为止,我还没有找到原因。下面是…的代码
感谢所有的帮助!!
string strConnString = ConfigurationManager.ConnectionStrings["WISCConnectionString"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
getReport();
}
protected void getReport()
{
DataSet ds = getData();
ReportDataSource rds = new ReportDataSource();
rds.Name = "ParameterCorpBillDate";
rds.Value = ds.Tables["ParameterCorpBillDate"];
rds.DataSourceId = "SqlDataSource1";
ReportViewer1.LocalReport.ReportPath = "Reports'rptPeriodAnalysisCorpBillDate.rdlc";
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(rds);
ReportViewer1.LocalReport.Refresh();
ReportViewer1.Visible = true;
}
private DataSet getData()
{
DataSet ds = new DataSet();
SqlConnection sqlConnection = new System.Data.SqlClient.SqlConnection(strConnString);
SqlDataAdapter dataAdapter = new System.Data.SqlClient.SqlDataAdapter();
SqlCommand select = new System.Data.SqlClient.SqlCommand("uspWRPeriodAnalysisCORP_BillDate_noparam");
select.CommandType = CommandType.StoredProcedure;
select.Connection = sqlConnection;
//select.Parameters.Add("@custid", SqlDbType.VarChar).Value = "SON";
//select.Parameters.AddWithValue("@period_startdt", SqlDbType.VarChar).Value = "01/01/2011";
//select.Parameters.AddWithValue("@period_ENDdt", SqlDbType.VarChar).Value = "12/31/2011";
dataAdapter.SelectCommand = select;
dataAdapter.Fill(ds, "ParameterCorpBillDate");
return ds;
}
从以前的用户帮助…ReportPath = "Reports'rptPeriodAnalysisCorpBillDate. "- Hans Passant Sep 14 '11 at 21:49