title: SSRS simple nested IIF condition?
body: <p>Please have a look at the below expression</p>
  
  <pre><code>="Active : " &amp; IIF(Parameters!lsSSelect_Active_Type_s_.Value = "FXNULL","ALL",
   iif(Parameters!lsSSelect_Active_Type_s_.Value=1,"Active",   
   iif(Parameters!lsSSelect_Active_Type_s_.Value=2,"Inactive","N/A")))
  </code></pre>
  
  <p>Now user have 3 options, 1, 2 or FXNULL. 1 and 2 can display Active and Inactive correctly but when user select "FXNULL", it's throwing error.</p>
  
  <pre><code>The Value expression for the textrun contains an error: Input string was not in a correct format
  </code></pre>
  
  <p>Now in order to do a testing to make sure the comparison between <code>FXNULL</code> working fine, I tried the below expression and working fine</p>
  
  <pre><code>="Active : " &amp; IIF(Parameters!lsSSelect_Active_Type_s_.Value = "FXNULL","ALL","N/A")
  </code></pre>
  
  <p>What's wrong with the first expression?</p>