how to preserve carriage returns and new line feeds?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SAM - 12 Jul 2008 14:59 GMT

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?

Reply to this Message

Parker - 13 Jul 2008 13:46 GMT

Did you use CHR(13) + CHR(10)?

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

Reply to this Message

ben.koolstra@besam.nl - 13 Jul 2008 18:46 GMT

> 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
[quoted text clipped - 6 lines]
>
> Does anyone have any suggestions to resolve this issue?

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))

Reply to this Message

carolus.holman - 21 Jul 2008 21:06 GMT

I used this, the other solution weren't working:

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

> > 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
[quoted text clipped - 11 lines]
>
> replace(text,char(10),char(13)+char(10))

Reply to this Message