Post reply

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

  • April 9, 2014 at 10:04 am

    #306222

    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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply