FMabey
asked on
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!Your Field.Valu e, "DataSource"),CHR(10),VbCr Lf)
However, this is not working.
Can anyone please advise?
Thanks
Carriage-Returns.docx
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!Your
However, this is not working.
Can anyone please advise?
Thanks
Carriage-Returns.docx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Jimhorn,
I've done just that. Thanks!
I've done just that. Thanks!
Thanks for the grade. Good luck with your project. -Jim
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