If a user clicks on Select All for a Allow multiple values for parameter Then I need to show All selected right nowI am using Join(Parameters!Name.Label, ", ") so it shows All the parameter values separated by comma.

Hi, As you posted, we can use the Join function in the expression to show all select values of a multi-value parameter. However, if this cannot meet your needs, please eleborate the requirement briefly, and then I will try to assist you to achicve it. For more information about Using Multivalue Parameters, please refer to: http://msdn.microsoft.com/en-us/library/aa337292(v=SQL.100).aspx Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

I have a request that when user selects a multivalues/ all in the parameter checkbox then instead of showing all the names, just show "All" as report parameter on the header of the report. ould you please suggest how i could fulfill this requirement. thanks tony for your reply.

Hi, How do you specify the available values of the multi-value parameter? If you specify 5 static available values for parameter P1, we can change the expression in the textbox to =IIf(Parameters!P1.Count=5,"All",Join(Parameters!P1.Value,",")) If you specify the available values to Get values from a query, and the Dataset is DataSet1, Value field is ProductKey, Label field is ProductName, then we can change the expression in textbox to =IIf(Parameters!P1.Count=Count(Fields!ProductKey.Value, "DataSet1"),"All",Join(Parameters!P1.Value,",")) Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.