Welcome to MSDN Blogs Sign in | Join | Help

Where did "Select All" go in SQL Reporting Services 2005 SP1?

If you've installed SQL 2005 SP1 and use Reporting Services regularly, you've probably noticed something is absent if you utilize multi-valued parameters: namely, "Select All" no longer appears at the top of your parameter list.

In SP1, Select All was removed because it could play havoc with SQL Analysis Services performance if you queried a cube with the Select All option specified.

To work around this issue, try this link and read the "Adding an All Member to a Multivalue Parameter" section:

http://msdn2.microsoft.com/en-US/library/ms155917.aspx

A hotfix has also been created to re-enable the feature, and a public article (Q919478) is in the process of being written to document same. The article may take some time to make it to support.microsoft.com, so don't assume it will be active any time soon.

 

Published Tuesday, June 06, 2006 5:39 PM by russch

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# re: Where did "Select All" go in SQL Reporting Services 2005 SP1?

Thursday, July 27, 2006 7:20 PM by John Beatty
There is no "Adding an All Member to a Multivalue Parameter" where you led us.  I guess we're really not supposed to do it.

# re: Where did "Select All" go in SQL Reporting Services 2005 SP1?

Sunday, July 30, 2006 6:48 AM by russch
BOL was updated last week, and it looks like the topic has been modified. You an find the old one in google cache (http://72.14.209.104/search?q=cache:2TofjFp9jToJ:msdn2.microsoft.com/en-us/library/ms155917.aspx+working+with+parameters+in+reporting+services+%22all+member%22&hl=en&gl=us&ct=clnk&cd=2) or in older version of BOL.

# re: Where did "Select All" go in SQL Reporting Services 2005 SP1?

Thursday, August 03, 2006 11:41 AM by Puja
Hi,
I am looking for the workaround for "select All" when using multivalued parameters. I couldnt find the hotfix. I did update SP1 for 2005 and also ran this hotfix which doent address this issue-->Cumulative hotfix package (build 2153) for SQL Server 2005.

# re: Where did "Select All" go in SQL Reporting Services 2005 SP1?

Friday, August 04, 2006 1:06 PM by russch
The hotfix rollup you installed does not include the fix (you need Hotfix 810). Call product support and ask for it.

# re: Where did "Select All" go in SQL Reporting Services 2005 SP1?

Monday, August 07, 2006 2:35 PM by Puja
Thanks for the tip but can you direct me to a download link for Hotfix 810. Is this link supposed to resolve the Select ALL issue?
http://support.microsoft.com/?kbid=919636

# re: Where did "Select All" go in SQL Reporting Services 2005 SP1?

Monday, August 07, 2006 6:36 PM by russch
You cannot download it. You must call product support and then they can package and send it to you.

# re: Where did "Select All" go in SQL Reporting Services 2005 SP1?

Friday, August 11, 2006 2:58 PM by aqualls
What information is required to get this hotfix from microsoft. My support dept. Doesn't want to try to contact Microsoft with a KB number. they say it is required.

Thank you

# re: Where did "Select All" go in SQL Reporting Services 2005 SP1?

Friday, August 11, 2006 3:06 PM by furmangg
Another option would be just to use the ReportViewer control and host it in a custom web page. The ReportViewer control that's currently in release (http://gotreportviewer.com) still has the select all option.

# re: Where did "Select All" go in SQL Reporting Services 2005 SP1?

Tuesday, August 15, 2006 8:41 AM by russch
At the risk of sounding rude, let me be clear: The ONLY way to get this hotfix is to call product support, period. You must call with the article number (919478) and ask for the fix. That is the ONLY supported way of getting the fix.

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker