asked on

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.

Howard Cantrell

Have you tried enlarging the textbox? Also make sure the textbox is set to grow.

jnikodym

ASKER

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

Howard Cantrell

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

https://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.

jnikodym

ASKER

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.

ASKER CERTIFIED SOLUTION

ValentinoV

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jnikodym

ASKER

Thank you very much. That solved my problem.