I have some data I'm getting back which has address details. The data is separated using a /r. In C# code you can obviously split the /r and replace this with a <br> tag to insert a break. Does anybody know how I can do this within reporting services, is it possible to write some expression to do this? Cheers.
Thanks
Use
=REPLACE(Fields!Address.Value, "/r", vbCrLf")
|||I've tried it and it doesn't work, I've added a quote before the replace vbCrLF but makes no difference|||Sorry, it should be:
=REPLACE(Fields!Address.Value, "/r", vbCrLf)
No quotes as vbCrLf is a built in variable.
sql
No comments:
Post a Comment