Wikis - Page Details

First published by SathyanarrayananS (8Microsoft Community Contributo)
When: 27 Jul 2013 11:07 AM
Last revision by Ed Price - MSFT (aMicrosof)
When: 5 Sep 2013 6:49 PM
Revisions: 6
Comments: 2

Options

Can You Improve This Article?

Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.

SSRS: Multiple Ways to Split a String into Multiple Lines

This post is about how to split a string inside textbox or field into multiple lines .

Below are the options to split a string into multiple lines :

i.) using VBCRLF
ii.) using chr(10)
iii.) using <br> HTML tag

Consider for example that I have a string "Microsoft Reporting Tool - SQL Server Reporting Services" inside a textbox ,
and we want to split the string into two lines inside textbox as shown below :

"Microsoft Reporting Tool -
SQL Server Reporting Services"

--Using VBCRLF :

="Microsoft Reporting Tool -"+ VBCRLF +

"SQL
 Server Reporting Services"

--Using chr(10) :

="Microsoft Reporting Tool -"+ chr(10) +

"SQL
 Server Reporting Services"

--Using HTML tag <br> :

="Microsoft Reporting Tool - <br> SQL Server Reporting Services"

To add expressions using VBCRLF and chr(10), just right-click on textbox - > Expression (fx)

To add expression using HTML tag <br> - > click inside textbox - > Create Placeholder ... - > Placeholder properties - >
General - > value - > Expression (fx)
and also in the same window, select the option HTML - Interpret HTML tags as styles