title: SSRS 2008 - Filter Expression at Tablix Properties
body: <p>I wrote the query and did not set up the "where clause" because I would like to have all values returned.</p>
  
  <p>I set up the filter at the Tablix properties and allowed the users to select them as parameters.</p>
  
  <p>I also set up a parameter to filter the result as well. Let's say that parameter's name is "p_location".</p>
  
  <p>What I would like to do:</p>
  
  <ol>
  <li><p>If the user does not select anything in the parameter box, or parameter box is blank, return everything.  Another word, do not filter anything.</p></li>
  <li><p>If the user types something in the parameters, filter that parameter against a field name.</p></li>
  </ol>
  
  <p>I wrote this in the expression and it does not seem to work:</p>
  
  <p>= IIF(IsNothing(Parameters!p_Location.Value),"",Fields!Location.Value)  </p>
  
  <p>Then, I select LIKE to be my operator</p>
  
  <p>Then, the value box = Parameters!p_location.value</p>
  
  <p>The user will type the search using the % at the end in order to obtain the result.</p>
  
  <hr>
  
  <p>Is it possible to set up with the word "ALL" in this parameter box to return everything? If I set it up this way, the filtering might not work because it contains some value, instead of blank.</p>
  
  <hr>
  
  <p>Thanks in advance. </p>