开发者

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

开发者 https://www.devze.com 2023-01-05 03:44 出处:网络
I need to pass a value as a parameter from AS开发者_如何学编程P.Net application to SSRS Report.How can i do this?Can anybody help me ?

I need to pass a value as a parameter from AS开发者_如何学编程P.Net application to SSRS Report.How can i do this?Can anybody help me ?

Thanks in advance.


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();


You can pass the parameter values in the URL used to get the report.

Also you should disable the "Promt user (for parameters)" in /reports/Pages/Folder.aspx for your report.

Example of setting a parameter named ParameterName: /Reports/Pages/Report.aspx?...&ParameterName=ParameterValue

Viewing Reports with a Browser

0

精彩评论

暂无评论...
验证码 换一张
取 消