Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

how to preserve carriage returns and new line feeds?

0 views
Skip to first unread message

SAM

unread,
Jul 12, 2008, 9:59:02 AM7/12/08
to
I am reading in ntext values in a textbox using SSRS 2005. When previewing in
BIDS, the carriage returns are maintained but when deployed to the server and
viewing the results in the browser, the carriage returns are ignored.

Does anyone know how to preserve carriage returns in SSRS 2005? I have tried
using chr() but nothing changes. Someone suggested creating a function to
read in the values then re-rendering into HTML to see if it will preserve the
formatting.

Does anyone have any suggestions to resolve this issue?

Parker

unread,
Jul 13, 2008, 8:46:52 AM7/13/08
to
Did you use CHR(13) + CHR(10)?

Sometimes the order can be important, and you need to use both

ben.ko...@besam.nl

unread,
Jul 13, 2008, 1:46:47 PM7/13/08
to

I had the same issue and it was solved by replacing CHR(10) with CHR
(13) + CHR(10)

replace(text,char(10),char(13)+char(10))

carolus.holman

unread,
Jul 21, 2008, 4:06:19 PM7/21/08
to
I used this, the other solution weren't working:

=REPLACE(Fields!YourFieldHere.Value,CHR(10), vbcrlf)

0 new messages