title: SSRS 2008 Filtering Multi-Value Parameter for Display in Report Header
body: <p>I have a multi-value parameter (Param_Locations) from which a user can select multiple service locations (e.g. LocationA, LocationA Optical Shop, LocationB, LocationB Optical Shop, ...). The selection of these locations is important for the dataset I will be generating. I am then able to display the selected locations in the header of the report using: =Join(Parameters!Param_Locations.Label).</p>
  
  <p>The issue I have is that I want to filter out any location that has the word "Optical" in the Label. I do not want those locations to show in the report header even though they may have been selected from the drop-down selection list.</p>
  
  <p>I have tried using the Filter() function to no avail. Any ideas would be appreciated.</p>
  
  <p>Regards!
  Babak C
  Phoenix, AZ</p>