sql - SSRS Select All Causes URL to Exceed Max Length -

i have 250 items ids 6-7 characters long. have them organized 3 classes 8 sub classes in each class. when using report, users have ability use cascading drop down lists filter list of items. however, when report loads, users want items visible.

the report parameters being passed via url web service retrieve data me.

i have set items report parameter multiselect, have manually added value "all" default parameter , have included "all" option in list of resources using following query:

select 'all' itemid union select itemid itemid (select distinct itemid       itemmaster       (itemsubclass in (@itemsubclass)) , itemclass in (@itemclass))       order itemid) derivedtbl_1 

when program logic detects 'all' parameter items not filter items , sends full list report.

there few problems have set up

1. the 'all' selection appears buried in list of items. i.e. (select all) first, followed numerical items, followed 'all', followed alphabetic items.
2. the (select all) item still appears in list because multiselect parameter ad if user selects it, 250 items selected , receive max url characters error.

so, there easy way allow multiselecting items items list (within reason i.e. 10 max keep me under url error), disabling (select all) option, , moving custom 'all' option top of list in place?

i think can rid of all. need manipulate behavior of "select all" behave i.e. no filters applied in url. way can count rows in dataset , compare parameter count selection.

something like:

=iif(parameters!itemid.count=countrows("itemiddataset"),"all",join(parameters!itemid.value, ", ")) 

make sure when doing count comparison based on if have removed "all" option.

here helpful articles explain scenario.

http://www.mssqltips.com/sqlservertip/2844/working-with-multiselect-parameters-for-ssrs-reports/

http://dataqueen.unlimitedviz.com/2011/06/how-to-default-to-all-in-an-ssrs-multi-select-parameter/

hth