SSRS Concatenate Two String Fields

Want full access?

100% FREE, 4 508 fellow members
Video Description: In this SSRS lesson we will show you how to concatenate two string fields together so they can be displayed together in a single cell.

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. See screenshot below.

 

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 

Did you find this page useful? +4  |  -0
(4 Votes)

Exactly what I needed to use in design view
Helped me!
Want to add a comment


no comments

We had our legal consultation, and today we'll send our request to create a 'not for profit' company, to companies house.

£5,000 is our first target to cover basic operational costs, investments and salary for next 2-3 months.

just 9 days left
£867 ($1,140)
raised of £5,000 target
17%
raised


Sharing is caring :)
Pawel Olejniczak donated £20
Thomas Tabert donated $10
 Katrina Kilcoyne donated £20
 Jason Batters donated £20

Official Sponsors