suppress select all option in multi value parameters

  • Is there any way when using to multi value parameters of disabling the select all option so that it is not visible to the user and cant be selected?

  • I beleive that there is no such option. But, if someone knows the solution please post. I am also interested in knowing it.

    -Vikas Bindra

    -Vikas Bindra

  • You cannot suppress the select all option like you said since this is a built in function. What you could do is, go to the data tab, create a new dataset (TEXT query or function or stored procedure) to generate you drop down. Then go to Report->Report Parameters. Add the new parameter from Query and DO NOT CHECK the Multi-Value option. Hope this works for you.

  • sam (1/8/2009)


    You cannot suppress the select all option like you said since this is a built in function. What you could do is, go to the data tab, create a new dataset (TEXT query or function or stored procedure) to generate you drop down. Then go to Report->Report Parameters. Add the new parameter from Query and DO NOT CHECK the Multi-Value option. Hope this works for you.

    :unsure: wont doing this mean that the user is unable to make multiple selections though?

  • If the you want the user to make multiple selections you can use the join function in your parameter and change the parameter equation from parametername = Fields!name.value to parametername IN Fields!name,value. If this does not help try and explain exactly what you are trying to do. I understand you want to be confidential and all but a little bit details may help. cheers! 🙂

Viewing 5 posts - 1 through 4 (of 4 total)

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