dianemarie
Instructor
Hello, we have a report heading that shows the selections a user makes in a multi-value parameter separated by commas (in this case for profit centers). Example of formula for doing this:
=join(Parameters!ProfitCenter.Label,", ")
When the user selects "Select All", I would like it to say "All" instead of "Profit Center A, Profit Center B, Profit Center C" etc. My parameter is a String, Multi-Value, pulling available values from a dataset query, and pulling default values from the same dataset query. The main query says:
Where lo.profit_center_name in (@ProfitCenter)
Typically the user tends to select 1,2, maybe 3 profit centers, or all, and we have over 10 so when they pick all the report label is needless to say overly long. Thank you for any help.
=join(Parameters!ProfitCenter.Label,", ")
When the user selects "Select All", I would like it to say "All" instead of "Profit Center A, Profit Center B, Profit Center C" etc. My parameter is a String, Multi-Value, pulling available values from a dataset query, and pulling default values from the same dataset query. The main query says:
Where lo.profit_center_name in (@ProfitCenter)
Typically the user tends to select 1,2, maybe 3 profit centers, or all, and we have over 10 so when they pick all the report label is needless to say overly long. Thank you for any help.
