November 25, 2013 at 2:39 pm
Goal:
If you have selected "(Select All)" no matter what if you also have selected 1,3 and 4, the textbox shall display "All" only. If you have selected for instance selected 1,3 and 4 only the value shall display 1,3,4.
Problem:
I do not know how to do it. I can retrieve one or many countries but not in this context.
Information:
I'm using the code to display the selected data
= Join(Parameters!Country.Label,", ")
November 26, 2013 at 9:14 am
Assuming that you get the parameter choices from a dataset then how about:
1. Checking the number of selected items in the multivalue parameter against the number of choices available from the dataset.
2. If even then all have been selected otherwise show each individually.
=iif(Parameters!ParameterName.Count = count(Fields!ParameterFieldInDateSet.Value,"DatasetName"),
"All items (Select All)",join(Parameters!ParameterName.Value,","))
Fitz
November 26, 2013 at 10:38 am
Something like this should work.
1. Join the parameter values
2. See if the desired string is in the joined parameter values
3. Print the appropriate value based on the result of step 2
iif(InStr(Join(Parameters!<param_name>.Label, ",") "All"), "All", join(Parameters!<param_value>.label, ", "))
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply