SSRS remove carriage returns

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
LVL 3
FMabeyAsked:
Who is Participating?
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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
 
dannygonzalez09Commented:
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
 
FMabeyAuthor Commented:
Hi Jimhorn,

I've done just that. Thanks!
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Thanks for the grade.  Good luck with your project.  -Jim
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.