Sign In | Feedback | Donate | Search
Katie and Emil Logo
Vote Yes! I like it! [+0]  |  Vote no! Dislike? [-0]
Author: by Katie Glownia

In this SSRS Tutorial I will show you how to concatenate two string fields. I will use SQL Server Reporting Services 2008 R2 but it should also work with SSRS 2005, 2008 and SSRS 2012.

To concatenate two or more fields using expression in SSRS. Please follow my SSRS tutorial.

Below we can see a table and we want to concatenate First Name with Surname to get Full Name.

 

First I Add new column to the Left.

 

Once new column exist we can type the header (Full Name), right click the cell where we want to perform concatenation and then go to Expression.

 

At the beginning of expression I will put First Name field and I will concatenate it with empty space using & " " the trick is to use & and if we use hard coded string we need to enlose it using double quotes " ". Next I will put & to concatinate my empty space with surname field.

See below final expression.

NOTE: If you field is not string data type (for instance integer) you might have to use function to convert it to string.

 

That is table after adding new column in Design view.

 

And the final picture shows the end result

 

I hope this ssrs tutorial will help you to concatenate fields and strings in SSRS.

Katie 

 

Upsss... Something went wrong and Google Ads on our website did not display.

Google ads sponsor FREE content on our website and without them it would not exist.

How to fix the problem?
  1. Check if the Google Search display any ads by searching the term Business Intelligence
    • If ads don't display, try different search terms and if there no ads then there might be a problem with your browser. If you made changes to your browser behaviour then undoing them will help.
    • If ads display then, refresh our page one more time, if the problem is still there than please contact us.
  2. Become 'No Ads Learner' Member or if you are already one Sign In.
Close
Take care
Katie & Emil
Well done! It seems Google Ads display properly now on our website.

Access our website's FREE content for FREE!