Hello. We are using asp .net and reporting services, and trying to pass a multi-value parameter into reporting services that will show data for multiple branches.
Dim paramList As New Generic.List(Of Microsoft.Reporting.WebForms.ReportParameter)
paramList.Add(New Microsoft.Reporting.WebForms.ReportParameter("BranchNumber", 1))
ReportViewer1.ServerReport.SetParameters(paramList)
pInfo = ReportViewer1.ServerReport.GetParameters()
Let me know if you have any suggestions!
Thanks.
Did you try passing "1,2,3,4" instead of "1" ?Jens K. Suessmeyer
http://www.sqlserver2005.de
|||We tried that also, without any luck.|||
We have already figured out how to move between seperate branches, we just want a corporate option that will show all branches as a whole.
Any ideas?
Thanks
|||There is no way to post the "All" option, you will either have to pass all values to display or use an additional (hidden) parametert which uses the "All" option behind the scenes, something like:Where SomeVar IN (@.TheValues) OR @.TheMagicParameter = 1 (Where TheMagicParameter is the magic hidden parameter)
Jens K. Suessmeyer.
http://www.sqlserver2005.de
