tag:blogger.com,1999:blog-9296511.post7528776247460212094..comments2023-07-29T06:13:05.725-05:00Comments on ICU MSCRM: Line Breaks for nvarchar TextArea fields in SQL ReportsUnknownnoreply@blogger.comBlogger3125tag:blogger.com,1999:blog-9296511.post-44546315993314253492008-10-07T15:01:00.000-05:002008-10-07T15:01:00.000-05:00Matt,This is great! I've had a need for this and c...Matt,<BR/><BR/>This is great! I've had a need for this and couldn't quite get to the solution you did. Thanks for sharing this!<BR/><BR/>Mike CrossMichael Crosshttps://www.blogger.com/profile/18165734789745761830noreply@blogger.comtag:blogger.com,1999:blog-9296511.post-42897607877495984452008-09-12T12:59:00.000-05:002008-09-12T12:59:00.000-05:00Yes, you can use +vbnewline if you want a new line...Yes, you can use +vbnewline if you want a new line after the contents of the field are displayed, but I don't think that helps if the actual content of the field's data value includes line breaks. So for example, if the content of the field is "Employer" and you want a new line displayed after that string is rendered, +vbnewline will do that, but if your single field contains multiple lines of text with line breaks, you might need to use the method described in this post - at least that's what I've found.Matt Wittemannhttps://www.blogger.com/profile/14476684868021392948noreply@blogger.comtag:blogger.com,1999:blog-9296511.post-9682707065823201882008-09-12T01:49:00.000-05:002008-09-12T01:49:00.000-05:00You can use ""+vbnewline in fields also.You can use ""+vbnewline in fields also.Anonymousnoreply@blogger.com