Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 495
  • Last Modified:

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.
0
jnikodym
Asked:
jnikodym
  • 3
  • 2
1 Solution
 
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
 
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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
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
 
ValentinoVBI 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
 
jnikodymAuthor Commented:
Thank you very much.  That solved my problem.
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now