SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Reporting Services Carriage Return

Often when designing a report you may find a need to concatenate values in an expression.  For example, you want a column with full names but your data source has names stored separately for first name and last name.  Easy enough you can write an expression like this:

=Fields!FirstName.Value + " " + Fields!LastName.Value

Problem solved right?  Well let's complicate things a little.  Let's say you not only want the full names but all addresses as well but you don't want it on the same line.  You need a carriage return so it looks like a normal address:

Devin Knight

123 Main Street

Jacksonville, FL 12345

As many times as I've used carriage return in reporting services I always seem to forget the syntax for it and have to go search for it.  That's usually the purpose for me writing blogs! 

Using the VbCrLf function I can get my line feed.  It's a call the VB for carriage return and line feed.  Here's the syntax to get my name and address like I need:

=Fields!FirstName.Value + " " + Fields!LastName.Value + VbCrLf +

Fields!Address.Value + VbCrLf +

Fields!City.Value + ", " + Fields!StateProvinceName.Value + " " + Fields!PostalCode.Value

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).


No comments.

Leave a Comment

Please register or log in to leave a comment.