SSRS Parameters : Select All
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
March 12th, 2007 1:17pm
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
March 12th, 2007 3:20pm
Thanks. Yes. That explains it.
March 12th, 2007 4:52pm
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?
August 11th, 2007 12:47am
Please disregard my previousmessage. I do not have SP2. I was misinformed by DBA by mistake.
August 11th, 2007 12:59am
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/
April 1st, 2011 10:22pm