Solved

SSRS Text String

Posted on 2013-10-31
6
486 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Need return values from a stored procedure 8 46
MS SQL Server select from Sub Table 14 42
SQL Server 2008 R2 service pack updates 5 46
How can I find this data? 3 28
Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

730 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