Hi

In SQL I have a text field that has my Address. When copy result is

But when I run this field in SSRS it puts it all in one line. The text is plain text and not html.

I tried split(fields!myaddress.value, "chr(13)").tovalue(0).tostring()

but this isn't working either.

How do I get my text to show multiline?

Thanks

Hello,

Are you sure that your data contains Windows conform new line characters? Because this sample below works:

Hi

The data I copied is directly from SQL. If I import this data to excel, it splits it into different rows. But when I do the Fields!Address.Value in SSRS it is put on one line.

Hope this helps