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

asp.net sql-server reporting-services reportingservices-2005 ssrs-2008
Santosh Chandavaram picture Santosh Chandavaram · Jul 1, 2009 · Viewed 18.2k times · Source

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

  • I need to pass report parameter from this ASP.NET page to the report server.
  • I want to pass region number based on user logged in, which is displayed on a label in ASP.NET page.

Thanks.

Answer

Mcbeev picture Mcbeev · Jul 1, 2009

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

Related questions

Change SSRS data source of report programmatically in server side

Today, for each customer, we deploy same SSRS reports folder and data source folder. The difference between these folders are the name of each folder and the connection string of the data source. We are using Report Server 2008 R2. Is …

Read More
Report Viewer Control (Web) Shows Blank Report

I have a web form containing a ReportViewer control, a DIV element so I can see that the page actually renders. I see that my page properly loads, I see the report service being accessed in Fiddler, but there is …

Read More
Call a stored procedure with parameter in c#

I can do a delete, insert and update in my program and I try to do an insert by call a created stored procedure from my database. This a button insert I make work well. private void btnAdd_Click(object …

Read More