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:
Join KEBI Academy
- 350+ BI Lessons
- Progress Tracking
- Live Webinars
- and more!