Lines in the text field SSRS VS05

Question

In the SSRS VS05 report, I have a field returned from the database that I combined.

Example:

SELECT Field1 + ' ' + Field2

I want to show this in a single text field in a report, but with a line break between two fields.

I tried:

Field1 + '\r\n' + Field2

but of course no luck.

What special characters can I use to force line breaks in my cell?

Answer 1

You can add line breaks in SQL by concatenating CHAR(10) + CHAR(13)your values.
However, I would advise you to do the formatting in the report, and not in the database. In this case, you must use the Visual Basic symbol vbCrLfin texbox.