Groups | Blog | Home
all groups > sql server reporting services > august 2006 >

sql server reporting services : Keeping newlines when displaying a text or ntext column in a textb


BoxFresh
8/25/2006 8:48:01 AM
I have a report that displays some details of a Claim that users have
entered. The data they enter contains newline characters. However, when I
bind this to a textbox in reporting services and display it all of the
newline characters are lost, and the text appears as one garbled lump, e.g.

Name:Brian Boyce
I have written to Bob B with details of
Contract, and
StartDate

in SQL Services report this is displayed as:
Name:Brian BoyceI have written to Bob B with details ofContract, andStartDate

I have set the CanGrow to true, so it will wrap if there is enough text, but
my newlines are lost.

Please can anyone help with this.
Thanks in advance,
BoxFresh
8/25/2006 11:33:01 AM
The PDF doesnt render properly either. I will try replacing the data with
Sysmte.Environment.NewLine and post back the results.

Thanks for reposponding.

BoxFresh
8/25/2006 11:41:02 AM
Steve,

It worked a treat. Thanks, you saved me a lot of frustrated work.

Brian

[quoted text, click to view]
Steve MunLeeuw
8/25/2006 11:53:31 AM
The line returns are probably dependent on rendering extension, PDF probably
renders the way you want it, but HTML doesn't. Can you run a fucntion in
the textbox to replace the line returns with System.Environment.NewLine?

Steve MunLeeuw


[quoted text, click to view]

AddThis Social Bookmark Button