title: SSRS 2008 multi-line data displaying as one line in report
body: <p>I have a report that is returning a one data field to a tablix control field.   The data field contains multi-line information in the database.  Example below.
  In SQL Server, <BR>
  "Dan Chief - Ceo - Indiana Office" <BR>
  "Dan Chief - " &amp; vbcrlf &amp; "Ceo" &amp; " - Indiana Office" <BR></p>
  
  <p>The vbcrlf's don't display in SQL Server but I have confirmed they are present by using instr() in SSRS.</p>
  
  <p>I want the data to display like this.   I can remove the hyphens and spaces.<br>
  Dan Chief<BR>
  Ceo<BR>
  Indiana Office</p>
  
  <p>But in the SSRS report it displays all on one line.   I have the autogrow check box selected/on and still nothing.</p>
  
  <p>Any ideas are welcome.</p>
  
  <p>Thanks.</p>