title: Add N/A if all fields are blank SSRS Expression
body: <p>I have a number of fields in one column of my table. I have it if field1 is blank display field2 and so on, What i trying to do now is if all fields are blank display N/A.</p>
  
  <p>What i have tried below;</p>
  
  <p><code>=IFF(ISNothing(Fields!field1.Value) &amp; IIF(IsNothing(Fields!field2.Value),"N/A",VbCRLF &amp; Fields!field2.Value))</code></p>
  
  <p>What this sometimes displays is field1N/A.</p>
  
  <p>Can anyone point me in the right direction?</p>
  
  <p>Thanks,</p>
  
  <p>UPDATE 1:</p>
  
  <p>I have also tried;</p>
  
  <pre><code>=IFF(ISNothing(Fields!field1.Value),"N/A",Fields!field1.Value &amp; IIF(IsNothing(Fields!field2.Value),"N/A",VbCRLF &amp; Fields!field2.Value))
  </code></pre>
  
  <p>That also did not work.</p>