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.


First, I’ll invoke the Expression Editor.


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


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


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


Leave a Reply

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

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

Facebook photo

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

Connecting to %s