Solved

SSRS Text String

Posted on 2013-10-31
6
472 Views
Last Modified: 2013-11-04
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
Comment
Question by:jnikodym
  • 3
  • 2
6 Comments
 
LVL 27

Expert Comment

by:planocz
ID: 39615072
Have you tried enlarging the textbox? Also make sure the textbox is set to grow.
0
 

Author Comment

by:jnikodym
ID: 39615086
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
 
LVL 27

Expert Comment

by:planocz
ID: 39615216
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
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:jnikodym
ID: 39615229
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
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 39621237
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
 

Author Comment

by:jnikodym
ID: 39621458
Thank you very much.  That solved my problem.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now