How to pass parameter TO SSRS report FROM ASP.NET, on which there is a report for the report

Question

I have an ASP.NET page that has a report viewer for accessing reports from Report Manager.

• I need to pass the report parameter from this ASP.NET page to the report server.
• I want to transfer the region number based on the registered user that appears on the shortcut on the ASP.NET page.

Thanks.

Answer 1

I assume that you are using remote report processing.

Then follow these steps:

ReportParameter p = new ReportParameter("ParamName", "ParamVal");
reportViewer1.ServerReport.SetParameters(new ReportParameter[] { p });

: http://msdn.microsoft.com/en-us/library/ms252178(VS.80).aspx

: http://www.codeproject.com/KB/reporting-services/ReportViewer2005.aspx