Hi,

I could be wrong as I'm still new to RS and SQL but I don't think it is possible to have Select All set as default.

Mike - your solution is fine except that the Select All option is internally generated and so isn't one of the fields in your dataset so isn't available to be selected. I'd love to be proved wrong here though as I've been struggling with this one.

So far the only solution to this that I've come across is to effectively manually re-create the Select All functionality by having an All field that you set up in your query. Trouble is there appears to also be no way to switch off the automatic Select All entry if you are using a multivalued parameter - which means you end up with both an All option and a Select All option in your list.

Like I said - I'd love to be wrong here but I think this is correct.

John