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

sql server reporting services : Lines in text column run together


Jeff
8/25/2006 4:40:01 PM
Hi,

I'm using SQL RS 2000. My report has a text column that contains line
breaks. When printing this column in on a report, all of the lines run
together.

I've tried using a grid and list view and neither work.

Any ideas? Is there a function I should be using?

Thanks.

SFrench
8/29/2006 12:06:02 PM
Are you using vbcrlf for the line breaks? I use that and it has always
worked for me.

[quoted text, click to view]
Jeff
8/29/2006 1:55:02 PM
What do I do with the vrcrlf? The source application SQL RS is reading from
is a Great Plains text column. So I don't have control over how the data
enters the field. I just want to report it out.
- J

[quoted text, click to view]
AddThis Social Bookmark Button