title: SSRS Expression for IF, THEN ELSE
body: <p>I am creating a field from tables with our shoretel phone system and i am intergrating reports via SSRS and i need some assisstance with an expression.</p>
  
  <pre><code>=if(Fields!ExitReason.Value 7,
  then if (Fields!ExitReason.Value 1,
  else if (Fields!ExitReason.Value 0,)))
  </code></pre>
  
  <p>Definition results should be:</p>
  
  <pre><code>=if(Fields!ExitReason.Value) = 7 then 1 else 0
  </code></pre>
  
  <p>I am try to get the field to  give me 7, 1 else 0. Any assistance would be great.</p>
  
  <p>Thanks,
  Arron</p>