SQLServerCentral Logo SQLServerCentral Logo
  • Articles
  • Editorials
  • Stairways
  • Forums
    • Forums home
    • Active threads
    • Latest topics
    • Most popular
    • Leaderboard
  • Scripts
  • QotD
  • Books
  • Blogs
  • Register
  • Login
  • Write for us
  • Menu
  • Articles
  • Editorials
  • Stairways
  • Forums
    • Forums home
    • Active threads
    • Latest topics
    • Most popular
    • Leaderboard
  • Scripts
  • QotD
  • Books
  • Blogs
  • Write for us
  • Register
  • Login
  • Home
  • Forums
  • Reporting Services
  • Reporting Services
  • Multi-Value with
    • Neer Saini

      Valued Member

      Points: 57

      More actions

      August 25, 2006 at 3:02 pm

      #172209

      Hi SQL SERVER Reporting Services Experts

      I have a report which accepts multi value - check box paramter, i remember when i was using SQL 2000 Reporting i use to automatically get the <Select ALL> options in that list on selecting all options gets selected. but when i am using SQL 2005 i dont get that option in the parameter list.

      Any Idea how to achieve that in the report. as my drop down list is too big for any uders who wants to select all they have trouble selecting all values one by one

      i appreciate your help on this.

    • jjerome00

      Say Hey Kid

      Points: 706

      More actions

      August 28, 2006 at 11:34 am

      #657167

      It's a problem with Service Pack 1 for SQL Server 2005, which removed the ability to "Select All". You should already know this from your other thread, but there is a hotfix & explaination for this on msdn:

      http://blogs.msdn.com/bwelcker/archive/2006/08/14/700189.aspx

    Viewing 2 posts - 1 through 2 (of 2 total)

    You must be logged in to reply to this topic. Login to reply

  • About SQLServerCentral
  • Contact Us
  • Terms of Use
  • Privacy Policy
  • Contribute
  • Contributors
  • Authors
  • Newsletters
Redgate logo