title: How do I write an if else statement in Reporting Services expression language?
body: <p>I would like to write a Reporting Services <code>"Expression"</code> that basically behaves as the following (pseudo code)...</p>
  
  <pre><code>if ([Fields!StateProvinceId.Value] == 1)
  {
     return "Ontario";
  }
  else if ([Fields!StateProvinceId.Value] == 2)
  {
     return "Quebec";
  }
  else if ([Fields!StateProvinceId.Value] == 3)
  {
     return "Manitoba";
  }
  // ...
  // more cases same pattern
  </code></pre>
  
  <p>I don't see this type of logic do I have to nest a bunch of IIF?</p>
  
  <pre><code>=IIF(Fields!StateProvinceId.Value = 1, "Ontario", IIF(Fields!StateProvinceId.Value = 2, "Quebec", IFF(Fields!StateProvinceId.Value = 3, "Manitoba", "Unknown Province")))
  </code></pre>