Monday, September 22, 2008

Programatically Passing Parameter to Reporting Service in C#

using System.Collections.Generic;


ReportViewer1.ShowCredentialPrompts = false;
ReportViewer1.ServerReport.ReportServerCredentials = new ReportCredentials("username", "MyPassword", "domain");
ReportViewer1.ServerReport.ReportServerUrl = new Uri("http://testuser/Reportserver");
ReportViewer1.ServerReport.ReportPath = "/Report Project State/Report1";
List parameters = new List();
parameters.Add(new ReportParameter("state", DropDownListStates.SelectedItem.Text));
ReportViewer1.ServerReport.SetParameters(parameters);
ReportViewer1.ProcessingMode = ProcessingMode.Remote;
ReportViewer1.ShowParameterPrompts = false;
ReportViewer1.ShowPromptAreaButton = false;
ReportViewer1.ServerReport.Refresh();

No comments: