SSRS Concatenate Two String Fields

Would you like to access members only content?
Log in (members) or try 7 days FREE trial
5 reasons to join KEBI Academy
7 days FREE trial

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.

Would you like to access members only content?
Log in (members) or try 7 days FREE trial
5 reasons to join KEBI Academy
7 days FREE trial
Did you find this page useful? +2  |  -0
(2 Votes)