September 23, 2005 at 10:13 am
Is there a way I can create parameters that can allow multiple values to be selected?
For example : I want to select multiple states when I run a report.
so my query would look like this :
select empname, empsal from emp where empstate in ('ca','va','ga')
Is this possible??????
Please help
-B
September 25, 2005 at 7:08 am
Simple answer, not really, unless you want your users to type in the single quotes and comma seperate the values in a text entry box.
Longer answer, the guys who wrote Hitchhikers Guide to Reporting Services presented an alternate way of doing this that involved modifying how Report Manager opened the report. Plus, if you're not using report manager (ie using your own web or windows front end) then you can definitely do this as you will be controlling the collection of parameters from your users.
Steve.
September 29, 2005 at 4:22 am
Of course , multiple params will be available, but in the next generation of Reporting services. See msdntv for details
Andrew/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply