Select All with SSRS 2008 Options

Question

I want the parameter to load the available values ​​from the query (or something else) and "allow multiple values". When I do this, the list starts with "Select All."

This is great, but there seems to be no way to set the Select All option, which is unacceptable in my case. This particular report will contain 8 optional parameters, and if htey has to select “Select All” several times, this is hardly optional.

Therefore, I create my own version of "..All" and the code for its adoption. I can by default, but then the user sees:

(Select All)
..All

It looks unprofessional. I scanned the network and did not seem to respond to this problem.

Is there a way to suppress (Select all) or achieve what I need? Any ideas?

Answer 1

In fact, the answer turned out to be that you should set your available values ​​and default values ​​to the same dataset and field.

If you do this, SSRS will automatically select each option in the list. This is not very, but it works.

, , "". SSRS " " " ". NULL, SSRS , .

.

Answer 2

Split() .

, varchars

SELECT 'A' UNION SELECT 'B'

:

=Split("A,B",",")