Search
Twitter
« Creating Custom Labels for an SSRS Gauge | Main | Querying Extended Properties on SQL Server Columns »
Friday
Nov122010

Creating a Line Break Within an SSRS Expression

When you need to include a line break within a textbox in SQL Server Reporting Services, a predefined Visual Basic constant may be used.  The vbcrlf, Visual Basic Carriage Return Line Feed, handles this quite nicely within an SSRS expression.  For example:

…will look like this when rendered:  

An advantage to using the vbcrlf within an expression is you can leave the text all in one textbox.  That means not having to worry about aligning two textboxes & removing padding from the top and bottom of both.  Word wrapping issues between textboxes are also eliminated.

For more information, see Constants Declared by Visual Basic.   

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments (1)

This was a life saver, thank you so much

January 29, 2013 | Unregistered Commenterctw

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>