title: Reporting services expression using Switch
body: <p>I couldn't get this expression working with reporting services. I have to use IF and ELSE IF statement. Thank you for any suggestions.</p>
  
  <pre><code>= Switch( IsNothing(Fields!field_date.Value),"", Fields!set_flag.Value=1,"Declined", Fields!field_name.Value) 
  </code></pre>
  
  <p>Here is what I am trying to do.</p>
  
  <pre><code>If(IsNothing(Fields!field_date.Value)) Then "";
  
  ElseIf Fields!set_flag.Value=1 Then "Declined";
  
  Else Fields!field_name.Value
  </code></pre>