Page 1 of 1

Carriage return in a string

Posted: Tue Mar 22, 2016 2:21 pm
by Jennypi
Hi

I'm planning to concatenate, in a string, several variables from my DB, separated with a carriage return character.
For example, my string would be : "aaa\nbbb\ccc".
The purpose is to have, in the report, one single (but very high) text field containing this variable. All the values would be displayed on the top of each other, like this:
aaa
bbb
ccc

Will it work? Should I use another carriage return separator (\n\r?)?

thanks.

Re: Carriage return in a string

Posted: Tue Mar 22, 2016 2:38 pm
by Jennypi
I'm joining an example.
Report.mrt
(4.85 KiB) Downloaded 322 times

Re: Carriage return in a string

Posted: Wed Mar 23, 2016 8:19 am
by Alex K.
Hello,

Please try to use the "\n" in the expression of the variable. In the database, you can use the CHAR(13) value.

Thank you.