title: SSRS 2008 R2 Remove White Space if Null
body: <p>I have a simple SQL Server 2008 R2 report with a textbox containing a few fields. I want to suppress the line if the value of a field is null. What would be the syntax for the expression?</p>
  
  <p>So my fields are...</p>
  
  <pre><code>Name
  AddressLine1
  AddressLine2
  AddressLine3
  CityStateZip
  </code></pre>
  
  <p>and I have expressions like this...</p>
  
  <pre><code>=First(Fields!AddressLine2.Value, "dsPersonData")
  </code></pre>
  
  <p>I was trying the expression below but getting errors</p>
  
  <pre><code>=IIF(Fields!AddressLine2.Value, "",True,False)
  </code></pre>
  
  <p>In other words I was trying to set the visibility to false if the value was an empty string but I'm not sure what the syntax would be.</p>