title: conditional filter SSRS
body: <p>My situation is</p>
  
  <ol>
  <li><p>I have a parameter, this is a list, allowing multi values. That mean the first record in the list is 'Select All'</p></li>
  <li><p>When user select All I need to include in my report all records that match with the list plus those that are blank. (My dataset is returning these)</p></li>
  <li><p>When user select only 1 or a few I want to include only these records. No those that are blank </p></li>
  </ol>
  
  <p>My problem: 
  I have a filter in my dataset that evaluate a parameter in a list, but I need to add a conditional filter to include a blank records when the selection will be "Select All" 
  I tried to use expression but this doesn't work</p>
  
  <p>Filter expression
  <code>Fields!NAME.Value in = Parameters!List.Value</code>  !!!!!!!!!!!!   Work Fine</p>
  
  <p>But I need to change it like as</p>
  
  <pre><code>If Parameters!List.Value  =  'Select All' Then
     Fields!NAME.Value in = Parameters!List.Value  or Fields!NAME.Value = " "
  Else
     Fields!NAME.Value in = Parameters!List.Value
  End
  </code></pre>
  
  <p>Can you give an advice who can I resolve it please !!!</p>
  
  <p>I'm working in SSRS R2</p>
  
  <p>Thanks!! </p>