SSRS - new line on report field

2019-09-04 07:03发布

问题:

My query returns a field like "In my honest opinion \r\n you guys can help me!". When I display this field on my report, the lines don't "break" as expected... what should I do?

回答1:

You can use this Expression:

=Replace(Fields!YourField.Value, "\r\n", System.Environment.NewLine)


回答2:

Found and answer:
Right Click textbox -> Expression and then:
=Fields!YourColumn.Value.ToString().Replace(",",vbCrLf)