title: Combining Two Address Fields in SSRS w/ Expression
body: <p>I'm trying to combine two fields into one text box in SSRS through an expression. If an address does have two entries, I'd like a line break between Addr1 and Addr2.</p>
  
  <p>What I have currently is:</p>
  
  <pre><code>=Fields!Addr1.Value &amp; VbCRLF &amp;
  Fields!Addr2.Value
  </code></pre>
  
  <p>But Addr2 may not have an entry so I'd like to be able to handle NULLS effectively.</p>
  
  <p>I've tried:</p>
  
  <pre><code>=Fields!Addr1.Value &amp; VbCRLF &amp;
  IIF(IsNothing(Fields!Addr2.Value),"",Fields!Addr2.Value
  </code></pre>
  
  <p>But that doesn't seem to work.  Any suggestions on how to handle this?</p>