Solved

SSRS remove carriage returns

Posted on 2013-11-11
4
1,106 Views
Last Modified: 2013-11-15
Hi all,

I am trying to remove the carriage returns (annoying squares shown in the attachment) from my report.

Currently, I am trying to use the following expression to return the value:
=Replace(First(Fields!YourField.Value, "DataSource"),CHR(10),VbCrLf)

However, this is not working.

Can anyone please advise?

Thanks
Carriage-Returns.docx
0
Comment
Question by:FMabey
  • 2
4 Comments
 
LVL 5

Expert Comment

by:dannygonzalez09
ID: 39638918
Can you post some sample text from the source table.. i want to give it a try

you can use this as a reference , if you don't have it already

http://www.theasciicode.com.ar/ascii-control-characters/carriage-return-ascii-code-13.html
0
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 39639643
Just a thought ...  If you're using stored procedures or views as the data source behind SSRS data sets, it would make more senese to 'scrub' CHAR(13) and CHAR(10)'s out in T-SQL using the REPLACE() function, then have to deal with them in SSRS.
0
 
LVL 3

Author Comment

by:FMabey
ID: 39650562
Hi Jimhorn,

I've done just that. Thanks!
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 39651012
Thanks for the grade.  Good luck with your project.  -Jim
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Tracking a Database Lock - SQL 2014 10 49
SQL query to summarize items per month 5 71
Install SSRS for developer 1 31
SSRS Report 2 46
In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
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 a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

828 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