protected void btn_showReport_Click(object sender, EventArgs e)
{
//ReportViewer1.Visible is set to false in design mode
ReportViewer1.Visible = true;
SqlConnection con = new SqlConnection(thisConnectionString);
SearchValue[0] = new SqlParameter("@Comp_Name", ddl_choose_valueToSearch.SelectedItem.Text);
/* Put the stored procedure result into a dataset */
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(new SqlParameter("@Comp_Name", ddl_choose_valueToSearch.SelectedItem.Text));
//cmd.Parameters.Add(new SqlParameter("@EndDate", endDate));
cmd.Connection = con;
cmd.CommandText = string.Format("Get_report_by_comp_name");
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
{
DataSet ds = new DataSet(); da.Fill(ds);
ReportDataSource datasource = new ReportDataSource("comp_form_view", ds.Tables[0]);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource);
//if (ds.Tables[0].Rows.Count == 0) //{
// lblMessage.Text = "Sorry, no data under this company!";
//} }
ReportParameter Comp_Name = new ReportParameter();
Comp_Name.Name = "Comp_Name";
ReportViewer1.ProcessingMode = ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri("http://dell-pc/ReportServer");
ReportViewer1.ServerReport.ReportPath = "/test Report/test1";
ReportViewer1.ServerReport.SetParameters(new ReportParameter[] { Comp_Name });
ReportViewer1.ServerReport.Refresh();
}
}
I use SSRS to generate report
I used the above code in "ShowReport" button to display report
I have this procedure in sql server:
ALTER PROCEDURE [dbo].[Get_report_by_comp_name]
@Comp_Name varchar(50)
AS
BEGIN
SELECT * from comp_form_view
WHERE Comp_Name = @Comp_Name;
END
I got this error:
Parameter 'Comp_Name' does not exist on this report
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentException: Parameter 'Comp_Name' does not exist on this report
Source Error:
Line 96: ReportViewer1.ServerReport.ReportServerUrl = new Uri("http://dell-pc/ReportServer");
Line 97: ReportViewer1.ServerReport.ReportPath = "/test Report/test1";
Line 98: ReportViewer1.ServerReport.SetParameters(new ReportParameter[] { Comp_Name });
Line 99: ReportViewer1.ServerReport.Refresh();
Line 100: }