title: RDLC: How to write the correct logical statement to display different address lines?
body: <p>I need to change the logic in <code>rdlc</code> statement to display 2 address lines in address section.</p>
  
  <p>The address section can be generated as one of the following:</p>
  
  <pre><code>Company Name
  John Smith
  Address 1
  Address 2
  City, State, Zip
  
  Company Name
  John Smith
  Address 2
  City, State, Zip
  
  Company Name
  John Smith
  Address 1
  City, State, Zip
  </code></pre>
  
  <p>I have a logic that displays empty line if Address 2 is empty or does not exists:</p>
  
  <pre><code>Company Name
  John Smith
  
  Address 1
  City, State, Zip
  </code></pre>
  
  <p>This is my statement:</p>
  
  <pre><code>  =First(Fields!Address.Value, "Dataset") &amp; VbCrLf &amp; 
    IIF(IsNothing(First(Fields!Address2.Value, "Dataset")) or First(Fields!Address2.Value, "Dataset") = "","",
    First(Fields!Addess2.Value, "Dataset")) &amp; VbCrLf &amp; 
    IIF(IsNothing(First(Fields!Address3.Value, "Dataset")) or First(Fields!Address3.Value, "Dataset") = "","",
    First(Fields!Address3.Value, "Dataset"))
  </code></pre>
  
  <p>What am I doing wrong and what is the right way to do it?</p>