Resources For IT Professionals
Page Details
  • First published by (8Microsoft Community Contributo)
  • When: 27 Jul 2013 11:07 AM
  • Last revision by (aMicrosof)
  • When: 5 Sep 2013 6:49 PM
  • Revisions: 6
  • Comments: 2
Options

Revision #4

Wiki  >  TechNet Articles  >  SSRS: Multiple Ways to Split a String into Multiple Lines  >  Revision #4
SSRS: Multiple Ways to Split a String into Multiple Lines
You are currently reviewing an older revision of this page.
Go to current version
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


Revert to this revision