SSRS : New Line Expression (For text box)

If you want to display the text in a new line (Or Newline ) at the text box, the following expression can be used.

=”Line 1 ” + VBCRLF + “Line 2”

Ex : =Fields!AddressLine1 + VBCRLF + Fields!AddressLine2 + VBCRLF + Fields!AddressLine3

OP:
Address1
Address2
Address3

Note: If VBCRLF is used first or last part the expression, it has no impact on result. If you want a line in the first or last, then use one more extra VBCRLF.

Reff: http://msbi-tidbits.blogspot.com/2011/12/ssrs-new-line-expression.html

Advertisements
By simplemsexchange Posted in SSRS

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s