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.
Video: You can watch Video Version of this tutorial using the button below or continue reading text based tutorial
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
