In multivalue parameters by default an option "All" was appearing. You can select both "All" and any of the individual parameters. However the latest report I created suddenly appeared with "(Select All)" as well as "All". (Select All) actually selects (or deselects) all items. Does anyone know where (Select All) came from, is this a new thing in SP2? How do you control it. Also, is there a functionality where you can select "All", but if you then select another paramater it automatically deselects "All"? Richard

Hello Richard, I believe that Reporting Services 2005 had the "Select All" option, then was removed in SP1, but is now back in SP2. Jarret

Thanks. Yes. That explains it.

I have SP2 applied to my SQL 2005 standard 64 bit edition but i do not see the "select all" or "all" in my reports mutivalue parameter configuration or when i run the report. Am i missing something?

Please disregard my previousmessage. I do not have SP2. I was misinformed by DBA by mistake.

In order to use the SELECT ALL feature, but pass the [ALL] member to the query, read this blog. http://tayloredbi.wordpress.com/2011/04/01/reporting-services-mdx-all-member-used-in-query-param-instead-of-member-set/