SSRS Concatenate Two String Fields

Learning Map
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.
Learning Status:  
 Log in

Related lessons:

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.


Want full article?
With KEBI Academy Membership you get:
  • 350+ BI Lessons
  • Progress Tracking
  • Live Webinars
  • and more!
Join KEBI Academy

Related lessons: