Force linebreak in VS05 SSRS textbox
In a VS05 SSRS report I have a field coming back from the database that I concatenated together.
Ex:
SELECT Field1 + ' ' + Field2
I'm wanting to show this in a single textbox on the report but with a line break between the two fields.
I've tried:
Field1 + '\r\n' + Field2
but of course, no luck.
What special characters can I use to force a line break in my ce开发者_JAVA百科ll?
You can add line breaks in SQL by concatenating CHAR(10) + CHAR(13)
to your values.
However I'd advise you to do formatting in the report rather than the database. In this case you would use the Visual Basic character vbCrLf
in the texbox.
精彩评论