Welcome to Forums Sign in | Join | Help | Forums
in Search


Concatenating

Last post 09-24-2003 2:12 PM by Bonnie Spear. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 09-23-2003 5:06 PM

    Concatenating

    I am trying to concatenate two string fields using the formula of Attribute1 + " " + Attribute2 but I cannot get Crystal to perform the concatenation. I've tried using the & sign in place of the + but still no luck. Does anybody have any ideas? Thanks, Dee
  • 09-24-2003 2:12 PM In reply to

    Concatenating

    Dee, Try the formula =FieldName1&" "&FieldName2 The other thing that you can do is to create a blank field on the report and drag in each separate field into the newly created field. For example if you create a blank field and type in the word "Total" then a space, then drag your first field into the "box" add a space or comma or whatever you want between the fields, then drag your second field into the "box". Hope this makes sense! Bonnie [i]--- Edited at 9/24/2003 2:14:23 PM by [Email Removed][/i]
Page 1 of 1 (2 items)