SQL Report Builder – How to Join Two Columns in Query Result
report-buildersql server
As the image below shows, on my DB I also have 2 columns that appear in the results pane separately – first name and last name – (lower part of image)
How do I join them together in the report builder?
Best Answer
In SSRS you don't join them in the result set (unless you do it in the data source) but you can use expressions in the design to show them concatenated in your report.
For example, Report Models are not supported and neither are ad-hoc queries through Report Models. This is an SSRS Express limitation which will manifest in Report Builder. Additionally, the language of the Supported Features of SSRS Express are somewhat ambiguous (nature of the English language) especially with regards to this line:
Ad hoc reporting through semantic models and Report Builder is not supported.
What does the "and" connect and how does it connect them? Is it the clause "semantic models and Report Builder" or is Ad hoc reporting not supported through both semantic models and Report Builder. Unfortunately, the answer to this question could be more readily parsed at Linguistics.SE. But I digress. Suffice it to say, Report Builder is available to you in SSRS Express.
Simple solution... posting for anyone else testing SQL 2016.
Do NOT supply a default SSRS Server URL during the installation process and it completes without error (Windows 2012 Datacenter and Windows 7 confirmed).
Best Answer
In SSRS you don't join them in the result set (unless you do it in the data source) but you can use expressions in the design to show them concatenated in your report.
Have a look at Expressions (Report Builder and SSRS).
Your expression would be something like