I am very new in SSRS. I want to passing parameter from windows
appln to SSRS.
-> select * from dbo.Employee where isActive = @active
query in my ssrs report.
-> in VS 2010 button click event.
rptViewer.ServerReport.ReportServerUrl = new Uri(@"http://localhost/ReportServer");
rptViewer.ServerReport.ReportPath = "/Custom Report/Custom Tempalte1";
rptViewer.ProcessingMode = ProcessingMode.Remote;
ReportParameter reportParameterCollection = new ReportParameter;
reportParameterCollection = new ReportParameter("active", "1");
rptViewer.ShowParameterPrompts = false;
here i am passing parameter(active) to '1' but it is not working for me. ie) it is not produce report for active = '1' .
what is wrong this . please kindly help me.