How to set multivalued parameter to Select All when given specific values to the parameter in SSRS

Question

Hi I have a multivalued parameter 'location' in which i am specifying values in parameter like 'Dallas','Chicago','Seattle'.how can i set the default value to 'Select ALL' I know how to make if values are from query,but how can i make all of them default when values are specified. thanks in advance

score 0 · Answer 1 · answered Sep 29 '14 at 06:49

0

below link might be helpful for your approach.

http://blog.hoegaerden.be/2013/12/18/the-select-all-parameter-option-ssrs/

answered Sep 29 '14 at 06:49

0537

993
8
15
32

score 0 · Answer 2 · answered Sep 29 '14 at 13:37

0

Right click Parameter > Properties > Default values and Use the same method you used to provide 'Available values' for that same parameter, so either specify values or use query. Hope this helps.

Wojtek

answered Sep 29 '14 at 13:37

wiciuo

95
1
9

How to set multivalued parameter to Select All when given specific values to the parameter in SSRS

2 Answers2