Table cell new line character

[Glenn]

I have the following inside of a table cell:

= "From: " + IsNull(Fields.OriginalLocation, '')
+ "\r\n"
+ "To: " + IsNull(Fields.NewLocation, '')
+ "\r\n"
+ "By: " + IsNull(Fields.Person, '')
+ "\r\n"
+ "On: " + IsNull(Fields.Date, '')

This does not work inside of the web report designer's "Value" field for the table cell. I have tried other methods as well. How can I ensure that there is a new line character between each of these?

[Ivet]

Hello Glenn,

Thank you for reaching out.

In the Web Report Designer, adding new lines in a table cell by using \r\n or Environment.NewLine in the Value expression will not work as these characters are not parsed as line breaks in expressions.

What you can do instead of using \r\n is to insert a new line inside the quotes, rather than escaping it. You can see exactly what I mean in the example below:

= "From: " + IsNull(Fields.OriginalLocation, '') + "
" +
 "To: " + IsNull(Fields.NewLocation, '')+ "
" +
 "By: " + IsNull(Fields.Person, '')+ "
" +
 "On: " + IsNull(Fields.Date, '')

Please give it a try and let me know if you have any questions.

Regards,
Ivet
Progress Telerik