Friday, March 23, 2012

Mult Select in SQL Reporting Parameters

Is there anyway to have a parameter that can be a multi select. Example
something that will allow multiple states to be selected?Sql Server 2000 Reporting Services does not directly support this
functionality. It is on our wish list for inclusion in a future release.
However there is an solution to this post on the GotDotNet.com web site:
http://www.gotdotnet.com/Community/Resources/Default.aspx?AFXPath=/Resource%5b@.ResourceId='2E882C0A-8D2B-4EAD-81BE-8E66C0941A18'%5d
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:u4DuLTjqEHA.2612@.TK2MSFTNGP15.phx.gbl...
> Is there anyway to have a parameter that can be a multi select. Example
> something that will allow multiple states to be selected?
>|||Here's a similar thread:
http://groups.google.com/groups?hl=en&lr=&threadm=eW7vUsFsEHA.2952%40TK2MSFTNGP10.phx.gbl&rnum=9&prev=/groups%3Fq%3Djerrynixon%2540gmail.com%26num%3D100%26hl%3Den%26lr%3D%26group%3Dmicrosoft.public.sqlserver.reportingsvcs%26scoring%3Dd
Here's another similar thread:
http://groups.google.com/groups?hl=en&lr=&threadm=F2B6BAF3-1667-4E1F-8A1A-54D0FC08DEA6%40microsoft.com&rnum=7&prev=/groups%3Fhl%3Den%26lr%3D%26scoring%3Dd%26q%3Dmulti%2Bselect%26meta%3Dgroup%253Dmicrosoft.public.sqlserver.reportingsvcs
One suggestion: if the parameter only needs TWO you could just have
two parameters that prompt the user for the same information. For
example, if you needed to select two months, you could have two month
parameters.
If you do not know the number to be selected - a custom interface is
the best solution - a free text with "1,2,3,4,5" entered by the user
is fine, though prone to error from human entry issues.
BR//Jerrysql

No comments:

Post a Comment