Share via

SSRS: Multiple Ways to Split a String into Multiple Lines

This post is about how to split a string inside text box 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 there is a string "Microsoft Reporting Tool - SQL Server Reporting Services" inside a text box and we want to split the string into two lines inside text box 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 optionHTML -  Interpret HTML tags as styles.

See Also