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.