Search code examples
c#asp.netreportingservices-2005

how can i pass a parameter from ASP.NET to SSRS Report?


I need to pass a value as a parameter from ASP.Net application to SSRS Report.How can i do this?Can anybody help me ?

Thanks in advance.


Solution

  • Follow the following line and try it...

            ReportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://MyPC/reportserver");
            ReportViewer1.ServerReport.ReportPath = "/ReportFolder/Reportname";
    
            Microsoft.Reporting.WebForms.ReportParameter[] Param = new Microsoft.Reporting.WebForms.ReportParameter[3];
            Param(2) = new Microsoft.Reporting.WebForms.ReportParameter("SDATE", "02/02/2002");
            Param(1) = new Microsoft.Reporting.WebForms.ReportParameter("EDATE", "09/06/2000");
            Param(0) = new Microsoft.Reporting.WebForms.ReportParameter("TASK", 0);
    
            View.ReportViewer.ShowParameterPrompts = false;
            View.ReportViewer.ServerReport.SetParameters(Param);
            View.ReportViewer.ServerReport.Refresh();