Home Forums Reporting Services Reporting Services 2008 Development how to concatenate two columns seperated by hifen in ssrs (Need Expression) RE: how to concatenate two columns seperated by hifen in ssrs (Need Expression)

  • April 9, 2014 at 12:01 pm

    #1704636

    mcfarlandparkway (4/9/2014)

    Hello,

    I have an SSRS report where I am grouping the table with system Name

    when I click on ALL in the dropdown it shows the report system wise.

    Problem is In the stored procedure the system name is showing as Douglas County and system id as 621

    In the parameters the system will show as 621 - Douglas County

    How can I write the expression in ssrs

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

    Try:

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

    Gerald Britton, Pluralsight courses