I have a huge list of locations on my report - like 450.  What I want to do is have a selection parameter that would give the option of some of them.  However, there are two that can be grouped, and then we also want an "All" function.

So my parameter gives the option to choose between 50 specific locations and then anything that starts with "VC1" and anything that starts with "VC2", and "All".  How then do I write a selection formula for this?  Here's what i had so far:

 

 

if {?Location} = "VC1" then (if left({@Location/DeviceName}, 3) = "VC1" then {@Location/DeviceName} else "")
else if {?Location} = "VC2" then (if left({@Location/DeviceName}, 3) = "VC2" then {@Location/DeviceName} else "")
else if {?Location} = "All" then {@Location/DeviceName}
else {@Location/DeviceName} = {?Location}

 

I'm getting an error on the last line. Any help? Thanks so much!