Hi In my report there is one column as "notes". In the database notes is a multiline text with carriage returns. I need to show this text in the report in multiple lines in same textbox. Need to split the text where carriage return presents. Now it is wrapping all the text.
Tried to do expression in SSRS as=Replace(field, CHR(13),VBCRLF) but it is just appending one space but not starting in new line.
Hi, It is working fine. it was my mistake I tried with Replace(field, CHR(10),VBCRLF) and thought it was not working.
answered Dec 18, 2013 at 03:25 AM