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.
| 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 & RegardsP.Narayanan. |
|
|
|
|
|
Passing parameter from windows appln to SSRS