Wednesday, April 14, 2010

Passing Parameters to Server Report

ReportViewer1.ShowParameterPrompts = false;
ReportViewer1.ShowCredentialPrompts = false;

ReportViewer1.ProcessingMode = ProcessingMode.Remote;
ReportViewer1.ServerReport.ReportServerUrl = new Uri("http://venkateswarlu/ReportServer");
IReportServerCredentials irsc = new CustomReportCredentials("username","password","domain");
ReportViewer1.ServerReport.ReportServerCredentials = irsc;

//ReportViewer1.ServerReport.ReportPath = "/AdventureWorks/CHCompanySales";
ReportViewer1.ServerReport.ReportPath = "/AdventureWorks/CHSalesOrderDetail";

ReportParameter[] rptParams = new ReportParameter[1];
rptParams[0] = new ReportParameter("SalesOrderNumber", "SO50750");

ReportViewer1.ServerReport.SetParameters(rptParams);
ReportViewer1.ServerReport.Refresh();

No comments: