SSRS Comma Delimited string to display on newline

reporting-services newline delimited-text
MikeTWebb picture MikeTWebb · Jul 21, 2014 · Viewed 7.4k times · Source

I have a Report in SSRS 2008. One of the columns contains a comma delimited set of values. An example cell displays:

Sting1, String2, String3

I would like to display these values in the cell on new lines:

String1
String2
String3

I've tried replacing the "," with "<br/>" and using HTML and then referencing HTML Decode but couldn't manage to get that to work.

I've also tried replacing the "," with "\r\n" and displaying but could not get that to work either.

Any ideas?

Answer

MikeTWebb picture MikeTWebb · Jul 21, 2014

Found an answer. In the Expression for the TextBox for the cell in the Tablix:

=Fields!YourColumn.Value.ToString().Replace(",",vbCrLf)

The VB Carriage Return Line Feed displays the values on separate lines

Related questions

Line break in SSRS expression

I'm having trouble adding a line break in SSRS 2008. I've tried all of these different ways but nothing is doing it. "+ chr(10) +" , "& chr(10) &" , "& chr(13) & chr(10) &" , "& vbcrlf &" , "+ vbcrlf +" , "Environment.NewLine" Here's my textbox expression: =…

Read More
The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted …

Read More
How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") but this is not working for me giving an error. Anyone please help me for expression ? I …

Read More