Post reply

Multi-Value with in SQL Server Repot

  • August 25, 2006 at 3:03 pm

    #116475

    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.

    Thanks

    Neer Saini

  • August 28, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • August 28, 2006 at 8:29 am

    #657098

    Neer,

    In the "Report Parameters" setup, there is a "Prompt" checkbox that says "Multi-value".  If you check this box, the report user will see a drop-down with all values; the very first one says "Select All".  If the user then checks the "Select All" option, all drop-down options are then automatically selected.  I hope this will solve the problem.

    Kind regards,

    Craig

     

     

  • August 28, 2006 at 10:58 am

    #657154

    Hi Craig,

    Thanks for your help. I have set up the way you told me But in SQL Server 2005 with Server pack 1, it does not give me option for ' Select all'. I have solved the problem by adding 'ALL' field and taking care of that in Stored Procedure.

    If you know somw other way, please let me know.

     

    Thanks

    Neer Saini

     

  • August 28, 2006 at 11:00 am

    #657155

    The "select all" checkbox was removed with SP1. See following link for more info and a workaround.

    http://nickbarclay.blogspot.com/2006/04/ssrs-disappearing-select-all-parameter.html

  • August 28, 2006 at 11:06 am

    #657157

    Thanks

    I know this.

     

  • August 28, 2006 at 11:26 am

    #657163

    Not sure if everyone knew, but there is now a fix for this:

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

  • August 29, 2006 at 6:48 am

    #657255

    Thanks. It is nice to know about Hotfix.

    Thanks

    Neer Saini

Viewing 8 posts - 1 through 7 (of 7 total)

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