Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Passing parameter from windows appln to SSRS

Author  Topic 

Narayanan
Starting Member

1 Post

Posted - 2013-05-02 : 12:55:54
Hi,
I am very new in SSRS. I want to passing parameter from windows

appln to SSRS.

-> select * from dbo.Employee where isActive = @active

in my report.

-> in VS 2010
rptViewer.ServerReport.ReportServerUrl = new Uri(@"http://localhost/ReportServer");
rptViewer.ProcessingMode = ProcessingMode.Remote;
rptViewer.ServerReport.ReportPath = "/Custom Report/Custom Tempalte1";
rptViewer.RefreshReport();
ReportParameter[] reportParameterCollection = new ReportParameter[1];
reportParameterCollection[0] = new ReportParameter("active", "1"); this.rptViewer.ServerReport.SetParameters(reportParameterCollection);
rptViewer.ShowParameterPrompts = false;
rptViewer.ServerReport.Refresh();

I want to pass parameter(active) to '1' but it is not working for me.
what is wrong this . please kindly help me.

Thanks & Regards
P.Narayanan.
   

- Advertisement -