Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1239
  • Last Modified:

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
0
FMabey
Asked:
FMabey
  • 2
1 Solution
 
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
 
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
 
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.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now