Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Combine multiple fields into one Post Reply Post New Topic
Author Message
VickiM
Newbie
Newbie
Avatar

Joined: 02 May 2011
Location: United States
Online Status: Offline
Posts: 28
Quote VickiM Replybullet Topic: Combine multiple fields into one
    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
IP IP Logged
Keikoku
Senior Member
Senior Member


Joined: 01 Dec 2010
Online Status: Offline
Posts: 386
Quote Keikoku Replybullet Posted: 02 May 2011 at 7:44am
Use & to concatenate strings.

ie: "a" & "b" gives "ab"
IP IP Logged
VickiM
Newbie
Newbie
Avatar

Joined: 02 May 2011
Location: United States
Online Status: Offline
Posts: 28
Quote VickiM Replybullet Posted: 02 May 2011 at 8:24am
Do I need to have {} or [] or () around the file names?
VickiM
IP IP Logged
Keikoku
Senior Member
Senior Member


Joined: 01 Dec 2010
Online Status: Offline
Posts: 386
Quote Keikoku Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.018 seconds.