SSRS: Expression – Concatenation

Constructing derived values through combining strings.

Combining string values is one of the most common requirements when building reports.

In this example, I will illustrate how to concatenate string values together to build a simple Contact field.
I’ll begin with a simple dataset containing Supplier data.
As you can see, the data contains four fields, two of which I want to combine into one field – Contact Name and Contact Title.
Instead of simply displaying both fields values in separate fields, I want to combine them.

1-expression-concatenation

First, I’ll invoke the Expression Editor.

2-expression-concatenation

Within the editor, I can either manually create my expression or select fields from a list.

3-expression-concatenation

Also, I may select from an extensive list of operators and functions to build the desired derived values.

4-expression-concatenation

Now, I have a “Contact” column that display both the contact’s name and their title.

5-expression-concatenation

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s