Santosh Chandavaram
Santosh Chandavaram

Reputation: 2490

How do I pass parameter TO SSRS report FROM ASP.NET page which has the reportviewer for the report

I have an ASP.NET page which has report viewer control to access reports from report manager.

Thanks.

Upvotes: 3

Views: 18873

Answers (1)

Mcbeev
Mcbeev

Reputation: 1529

I'm assuming your using remote processing of the report.

Then do the following:

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

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

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

Upvotes: 5

Related Questions