title: If statement with multiple else if statements in ssrs
body: <p>I have a Crystal Report that I am converting into SSRS and there is an important function that has multiple ELSE IF statements. Is there a way to get this to work in ssrs?</p>
  
  <pre><code>IF ({Command.FOLDERTYPE}= 'PC' and
  //1950 - SUB - MAJ FACILITIES SUBDIVISION, 1260 - SUBDIVISION
  ({Command.SUBCODE} = 1950) or {Command.SUBCODE} = 1260) 
  OR (({Command.FOLDERTYPE} = 'GD' and {Command.SUBCODE} = 900) //900 -    Public Construction
  or ({Command.FOLDERTYPE} = 'WA' and {Command.SUBCODE} = 900)
  or ({Command.FOLDERTYPE} = 'SS' and {Command.SUBCODE} = 900)
  or ({Command.FOLDERTYPE} = 'SD' and {Command.SUBCODE} = 900)
  or ({Command.FOLDERTYPE} = 'ST' and {Command.SUBCODE} = 900)) THEN
  'Subdivision'
  ELSE IF ({Command.FOLDERTYPE} = 'CO') 
  OR (({Command.FOLDERTYPE} = 'WA' and {@SubtypeCommercial} = true)
  or ({Command.FOLDERTYPE} = 'SS' and {@SubtypeCommercial} = true)
  or ({Command.FOLDERTYPE} = 'SD' and {@SubtypeCommercial} = true)
  or ({Command.FOLDERTYPE} = 'ST' and {@SubtypeCommercial} = true)
  or ({Command.FOLDERTYPE} = 'PC' and {@SubtypeCommercial} = true)
  or ({Command.FOLDERTYPE} = 'GD' and {@SubtypeCommercial} = true)) THEN
  'Commercial'
  ELSE IF ({Command.FOLDERTYPE} = 'SF')
  OR (({Command.FOLDERTYPE} = 'WA' and {Command.SUBCODE} = 1210) //1210 -  singe family
  or ({Command.FOLDERTYPE} = 'SS' and {Command.SUBCODE} = 1210)
  or ({Command.FOLDERTYPE} = 'SD' and {Command.SUBCODE} = 1210)
  or ({Command.FOLDERTYPE} = 'ST' and {Command.SUBCODE} = 1210)
  or ({Command.FOLDERTYPE} = 'GD' and {Command.SUBCODE} = 1210)) THEN
  'Single Family'
  ELSE IF {Command.FOLDERTYPE} = 'II' OR ({Command.FOLDERTYPE} = 'FR') THEN
  'Miscellaneous'
  ELSE IF {Command.FOLDERTYPE} = 'GD' THEN
  'Grading Permit - No subtype'
  </code></pre>