Post reply

Concatenate text with a field value

  • February 4, 2009 at 6:01 pm

    #204923

    How do you concatenate text with a field value in a group?

    I have a group and a SUM(Cost) which is a total for that group but I wish to add the following to the left of the grouping.

    Sub Total : =Fields!Customer.Value

    The Customer value in this case would be Company XYZ

    Kindest Regards,

  • February 4, 2009 at 7:51 pm

    #938568

    try something like:

    ="Sub Total:"&" "&Fields!Customer.Value

    Books on-line covers this as well.

    Mike

  • February 4, 2009 at 8:01 pm

    #938570

    That works.

    Cheers.

    Kindest Regards,

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

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