CODEWITHSUNDEEP
t-sqlreporting-services
Leonardo
Leonardo

Reputation: 11397

SSRS - new line on report field

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?

Upvotes: 0

Views: 1630

Answers (2)

tezzo
tezzo

Reputation: 11115

You can use this Expression:

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

Upvotes: 1

Leonardo
Leonardo

Reputation: 11397

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

Upvotes: 0

Related Questions