Print Page | Close Window

Combine multiple fields into one

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13079
Printed Date: 03 May 2024 at 7:53am


Topic: Combine multiple fields into one
Posted By: VickiM
Subject: Combine multiple fields into one
Date Posted: 02 May 2011 at 7:39am
Hello.
I need some help please.  Do you know how I can get data from multiple fields to merge into one.  I know how to do it in Access, I just can't figure it out in Crystal.
 
Here is what I need.
Employee Name: Trim([LAWSON_EMPLOYEE]![LAST_NAME])+", "+Trim([LAWSON_EMPLOYEE]![FIRST_NAME])+" "+[LAWSON_EMPLOYEE]![MIDDLE_INIT]
 
Employee Name: is the title I need to have the information placed under.
 
Thank you!


-------------
VickiM


Replies:
Posted By: Keikoku
Date Posted: 02 May 2011 at 7:44am
Use & to concatenate strings.

ie: "a" & "b" gives "ab"

Posted By: VickiM
Date Posted: 02 May 2011 at 8:24am
Do I need to have {} or [] or () around the file names?

-------------
VickiM

Posted By: Keikoku
Date Posted: 02 May 2011 at 8:36am
I believe you will first need to connect to the access DB and get the columns that you will need

You can use the DB expert to send the query via Add Command and it will be available on crystal as Crystal fields.

You will then use these fields in the formula.
I've never connected to an access DB though, so not sure how that might work.


Print Page | Close Window