Has "Select All" option been checked for Multi-Valued Parameter?

Greetings.

I have downloaded the patch to SP1 that restores the Select All choice for MVP. I am now wondering if there is a clean way (property?) to know if the Select All box is checked. My reason for needing this is that I want to selectively print a block near the top of the report that shows all of the parameters used to create the report. There are many blocks of parameters and each can have 5-10 possible choices. It would be much cleaner if I could print "all" rather than list all of the possible values, if in fact that category was not really used to filter the rows.

Perhaps I need to build a dynamic where clause but I would rather not go to that trouble if I can use a built in feature or property.

Thanks in advance. I hope this makes sense.

No, this is by design. All values will be passed as a comma separated string.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||One possibility that you may use is to add an 'All' option to your selection list. Then in your SQL you could use specify WHERE ((FieldName IN (@.Parameter)) OR ('All' = @.Parameter)). Ugly but functional.