SSRS how to add in New line

Thinna picture Thinna · Aug 19, 2013 · Viewed 27.4k times · Source

I am creating a string from stored procedure like this Name1 , Name2 , Name 3.... etc(This string is in one column). I want to display these name in a new line in my SSRS report like

Name1
Name2
Name3

I tried changing the string to

Name1 VbCrlf 
Name2 VbCrlf  
Name 3 

Doesn't seems to be working.

Please help me to resolve this issue.

Answer

Chris Latta picture Chris Latta · Aug 19, 2013

Use an expression like:

=Replace(Field!Names.Value, ",", VbCrLf)