all groups > sql server reporting services > july 2007 >
You're in the

sql server reporting services

group:

Select All in multi-value parameters


Select All in multi-value parameters KWC
7/20/2007 5:38:10 AM
sql server reporting services:
There has been quite a few posts about this appearing and disappearing when
SP1 is applied, etc. I now have SP2 loaded and the "Select All" option
appears in the dropdown. What I am wondering is, as of SP2, is there any way
to disable the "Select All" option or are we stuck with it again?

Reason I ask is I have implemented my own "All" option which is much more
efficient than passing a string of comma separated value (i.e. just passes a
zero).

Thanks
RE: Select All in multi-value parameters Mikey :0)
7/22/2007 4:34:01 AM
KWC, we did exactly the same thing when SP1 took away the select all option.
But the select all only appears when the Multi-value option is used in
reporting parameters. As we didn't want to allow multiple selections with
'select all' being one of them, we had a choice, either allow multi-select
and remove the hard coded select all, or don't use multi select and leave the
hard coded option in.

HTH Mikey :o)

[quoted text, click to view]
RE: Select All in multi-value parameters KWC
7/24/2007 2:26:02 AM
I do need the ability to select one or more options on the list so we need to
use multi-value parameters but it appears we must have the "Select
All"option. Here's another question, Can you have "Select All" checked by
default? If so how?

Thanks
KWC

[quoted text, click to view]
RE: Select All in multi-value parameters Mikey :0)
7/24/2007 5:48:06 AM
Actually there is a way of doing this, in the reporting parameters, on the
default values, select the 'from query' checkbox, and sleect the same dataset
you are using the populate the list, for the value field, again the same one
you are using to populate the list, preview the report and hey presto, select
all is the default option.

HTH

Mikey :o)

[quoted text, click to view]
AddThis Social Bookmark Button