how to concatenate two columns seperated by hifen in ssrs (Need Expression)

Question

 I have an SSRS report where I am try to group the table with system name. In the dropdown, when I click on ALL it shows the report system wise. Basically the problem is in the stored procedure. System name is showing as Douglas County and system id as 62

The system will show as 621 in the parameters - Douglas County
How can I write the expression in ssrs

="System Name: " + Fields!SystemID.Value + Fields!SystemName.Value

Answer 1

Properties of many report items can be set to an expression. Generally, Expressions help you control the content, design, and interactivity of your report. 

You can try using this:

="System Name: " + Fields!SystemID.Value + " - " + Fields!SystemName.Value 

Check out Msbi certification training that enables you to master MSBI tools like SSIS, SSRS, and SSAS using SQL Server. 

Answer 2

To concatenate two columns with a hyphen in SQL Server Reporting Services (SSRS), you can use an expression in the SSRS text box. Here’s the expression format: =Fields!Column1.Value & " - " & Fields!Column2.Value Explanation: Fields!Column1.Value and Fields!Column2.Value represent the values of the columns you want to concatenate. The & operator is used for concatenation in SSRS expressions. " - " adds a hyphen with spaces around it for readability. Example: If you have two columns named FirstName and LastName and want the output to look like John - Doe, the expression would be: 

 =Fields!FirstName.Value & " - " & Fields!LastName.Value  

This expression will display the concatenated string with a hyphen separator directly in your SSRS report text box.