Textbox based on select all of one of the parameters??

Question

Hello Friends,

I have a report in which I have a Store parameter.

On the report, I have a textbox which displays the selected stores name but I want the textbox to display as "ALL STORES" when all the values in the parameter are checked.

Right now, I just gave a try for this but did not work

=IIF((JOIN(Parameters!Stores.value).IndexOf("SelectAll")>= 0),"All Stores",(Join(Parameters!Stores.Label,", ")))

Please help me by suggesting a way to do this.

Thanks!

Answer 1

if you know how many stores there is in you parameter's list, then you could try something like this:

=iif(Parameters!Stores.Count = 10,"All Stores",Join(Parameters!Stores.Label,", "))

---

Call me Sam. Once a gunners always a gunners

Answer 2

That worked!

Thank you :)

Answer 3

this is what i used when i did not know the exact number

=iif(Parameters!StoreNumber.Count = Count(Fields!StoreName.Value, "ds_StoreNumber")
,"All"
,JOIN(Parameters!StoreNumber.Label,", "))