SSRS Text String

I have a note field in sql that i am pulling data from.  When i use this field in SSRS, all the text displays on one line.  I know there are breaks in the text.  How do i get the note text to show the breaks in SSRS?  If i use the same data field in Crystal Reports the line breaks show up.
jnikodymAsked:
Who is Participating?
 
ValentinoVConnect With a Mentor BI ConsultantCommented:
Could it be that your line break consists of only a CHAR(13)?  A regular CRLF is CHAR(13) + CHAR(10).  If that is the case, the following expression should "fix" the line breaks:

=Replace(Fields!YourNoteField.Value, Chr(13), vbCrLf)

Open in new window

0
 
planoczCommented:
Have you tried enlarging the textbox? Also make sure the textbox is set to grow.
0
 
jnikodymAuthor Commented:
The textbox is set to grow.  All the text shows up, just with no breaks.  

Example:
I would want the text to look like this
Second Row
Third Row

Below is how it looks in my report:
I would want the text to look like thisSecond RowThird Row
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
planoczCommented:
Here is an article that I wrote. It may or may not help

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/A_4282-SSRS-Report-Control-Your-Data-Length-in-a-table-column-per-column-line.html

Also their is a control that will push the line to the next row.
I can't remember but I think it is keys-- Ctrl -B, or Ctrl-Tab but I could be wrong.
0
 
jnikodymAuthor Commented:
The line breaks are already in SQL.  If i run a query on the same dataset i am using in SSRS and display the results to text it shows the data the correct way, in multiple rows.  For some reason SSRS is not formatting the data correctly when i add that field to my table.
0
 
jnikodymAuthor Commented:
Thank you very much.  That solved my problem.
0
All Courses

From novice to tech pro — start learning today.