Modifications in Multi-Valued param drop down

  • Hi All,

    I have kept an ALL option in my report which executes the SP for SELECT * condition. This is working fine.

    but it is a multi-valued parameter and will have Select All as the first option in the drop down.

    if the user select ALL or picks only a selected number of options in the dropdown, it will display the data correctly.

    but if he selects the SELECT ALL option, it is showing the error.

    now i have 2 questions:

    1. Can i hide that select all option provided by default in the drop down?

    2. Can i make my ALL option to be ALWAYS on TOP of the list?

  • Can i do any of these to handle it ?

    I will have my ALL option also selected while SELECT ALL option is chkd.

    so i thought of these:

    1. Deselect ALL option from the list while SELECT ALL is selected.

    2. Remove ALL option if possible and write the query for SELECT ALL itself.

    are they possible?

  • Just a guess but the error you get when selecting the "Select All" option which as far as I know has no bugs around the "Select All" is that maybe when you use the select all it applies 256 characters to the parameter which is set to 255 characters?

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

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