Clever Geek Handbook

How to display multivalued parameter value in SSRS textbox

I have a multi-valued parameter "client", I have almost 60 values ​​in the client parameter, my requirement displays the selected values ​​of the client in the title text box, but when I select the SELECT ALL option in the parameter I only display "ALL" and not display all 60 values.

I am using the below expression to display the parameter values ​​which are working fine

="For Client -" & Join(Parameters!Client.Value, ",")

now how can I display "ALL" and not display all client values ​​when I select the "Select ALL" option?

+3


source to share


1 answer


Try the following:



=IIF(Parameters!YourParameter.Count=Count(Fields!DataSetFieldName.Value, "Name OF Your DataSet"),"ALL",Join(Parameters! YourParameter.Value,","))
+6


source






More articles:


All Articles