Reporting Services Textbox "Line Break"

Question

I am bringing data over from Oracle into SSRS. One dataset pulls in a a string of names and initials divided by a semi colon. :

EX: Ratliff, J D;Schlue, R S

I would like to insert a line break after each semicolon and bold the very last line to display as follows:

Ratliff, J D;

Schlue, R S

Any ideas on how to accomplish this?

Answer 1

Hello James,

You could wrap that name field in an expression that simply replaces the ";" character with a line break character. That should give you the desired behavior.

Gerry Lee, SQL Server Reporting Services