Parameter

• sharonsql2013

  SSCertifiable

  Points: 5908

  More actions

  February 26, 2015 at 11:36 am

  #398088

  Is there a way to hide the Select All when we use Multiple values for Parameter....

  I want to see check boxes next to the values but don't want to show the "Select All" which is the default at the top.

  Any help will be appreciated.

• sql Sarah

  SSCrazy

  Points: 2081

  More actions

  February 26, 2015 at 2:51 pm

  #1780412

  That option is not available. In some of the articles I saw, it was turned off completely with SQL 2005 SP1 and then turned back on after that.

  This forum has a link to Microsoft Connect if you want to submit it, but also a link to how to limit the values returned from the dataset.

  http://go4answers.webhost4life.com/Example/remove-multi-value-select-all-drop-72402.aspx