Problem with multi-valued parameters since SP1

Problem with multi-valued parameters since SP1

• Gurudta

  MSFT dudes...is there any chance this <select all> functionality will be added back in SP2.
  

• Shital Shah

  I'm sorry but this simulation of the "All" element is garbage! With all due respect this borders on condescending....yeah I could write a report in ASP.NET too but hey I have Reporting Services for that right This is not a solution. Msoft put this option BACK! Is there any truth to this option coming back in a hotfix I read on a newsgroup that Chris Hays at MS told someone that the "All" option would be configurable. If anyone has any insight on this I'd appreciate it.
  Thanks,
  Adrian
  
  
  

• J.C.

  This was a breaking change in SP1 - documented in http://msdn2.microsoft.com/en-us/library/ms143380.aspx (scroll to: Adding the ALL member for multivalue parameters").

  There is updated BOL contents available on MSDN which explains how to change SQL-based queries to simulate the "ALL" element: http://msdn2.microsoft.com/en-us/library/ms155917.aspx (scroll to the section about "Adding an All Member to a Multivalue Parameter").

  -- Robert
  

  
  
  

• John Daldry

  Robert Bruckner MSFT wrote:

  Yes, based on all your feedback we decided to add it back for SP2 - exactly as it was in RTM. There will also be an upcoming SP1-based hotfix which will add back that functionality - however you will need to contact customer support to receive the hotfix once it is available. -- Robert

  
  
  That's great news, except the part where we have to contact anybody
  Why not just make the hotfix public, and our choice to install it or not
  
  So glad I haven't installed SP1, and maybe will jump right to SP2 instead :)
  
  By the way, is it possible to have SELECT ALL as an option in parameter setting window That'd be awesome.
  
  
  

• Krista

  Hi Robert,

  thank you, you made my day

  So long
  Lemmi

  
  

• Pietolit

  I agree with the other comments regarding the change to the Multivalue parameter Select All option in Reporting Services 2005 SP1. This will be difficult for us to implement as we reuse stored procedures to supply lists to different reports that allow users to choose a single or multiple values. You wouldn't want the option to choose "All" in a report that only really only allows for one choice. An option that would let the report designer choose whether to allow "Select All" in a multiselect would be preferable.
  

• mscheuner_garaio

  Hi,

  I totally agree with other comments. Removing this option realy sucks!!!!
  - We have delivered a numerous reports to serveral customer sites using this option.
  - I've just removed your "suggested solution" to this breaking change from reports on a customer site, replacing it with the build in all-option, while upgrading to 2005, so I've just have to put it back in again. - Thanks alot!

  - Is there a plan to reinforce the option and/or make it configurable for each report

  - Not using the SP isn't an option since there are some updates that we need and we use the policy to upgrade to the latest SP asap.

  /Michael

  
  
  

• Imran Hameed

  Am I the only one that thinks it would have just been easier to make the Select All box optional in the query builder Would have avoided this whole situation and made everybody happy.
  

• Dmitry_

  Hello Robert.  This is really a bummer.  I have just converted over to RS 2005 (from 2000) and implemented multi-select parameters in 15+ reports.  The select all option was a great option.  Something my end users would really use and like.  Now I will have to rewrite all the dataset queries for the parameters and the report queries to accommodate this, or expect my users to have to select three list items, one for each business unit, everytime they run the reports.  Three items may not seem like a big deal, but this list will be growing in the near future as our company evolves.

   

  Can't an option be created for a parameter in the parameter dialog (in the designer) to exclude the select all list item/option instead of just getting rid of it   Actually, this might be a nice option for long lists (10+ items) even for sql server datasources because you could force the user to make specific selections instead of just selecting all, which could make for some hairy IN clauses.

   

  I thought maybe skipping the SP would be an option, but obviously we would have to move to it sooner or later, since most sp's are all inclusive.

   

  Anyway, is this option gone for good

  
  

• Thomas Ivarsson

  I noticed this issue as well, however it seems the reportviewer control was not changed and still shows the select all. We had developed a VS2005 application so the user can select their reports to run in the same app via the control or launch in a seperate browser via the standrad http render to the report server. The app shows the select all but the http does not.

  We have created a report viewer web site that consumes the standard Http render and displays the report viewer just as it did in the pre sp1 with the select all. Coding is not too bad; real easy if there are no report parameters.

  Its a dumb work around but it works (until SP1 for VS2005)

  I agree that the select all should simply be a report configuration parameter; however I can see issues if the report builder is being being utilized but it should also allow for this option to be confgured as well,

  Bruce Van Buren

  
  

• meatz

  This is horrible. <<hanging head in disbelief>>
  

• chickplee

  Yes, based on all your feedback we decided to add it back for SP2 - exactly as it was in RTM.

  There will also be an upcoming SP1-based hotfix which will add back that functionality - however you will need to contact customer support to receive the hotfix once it is available.

  -- Robert

  
  
  

• Jean-Luc David

  HOORAY!!!!!!

  
  

• geanyee

  This is very, very disappointing. I will have to correct around 25 reports that we just modified not 6 months ago to use the multi-value parameter. This is going to take hours of work that we just don't have. I agree with steveareno - I think an option to exclude the select all option would be much more effective. This is really a HUGE step backwards in this reporting tool. We waited so long for the multi-value functionality and were very pleased with the way it worked when it was released. They have "fixed" something that we do not think was broken.

  
  
• Problem with multi-valued parameters since SP1