Writing Code
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Writing Code
Message Icon Topic: Concatenation Post Reply Post New Topic
Author Message
cardpogi
Newbie
Newbie
Avatar

Joined: 07 Aug 2008
Location: Dominican Republic
Online Status: Offline
Posts: 20
Quote cardpogi Replybullet Topic: Concatenation
    Posted: 15 Aug 2008 at 9:24am
Im trying to use Concatenation and im using this method can anyone tell me where im going wron? please go easy on me im pretty new....
"{ORIENTACIONES.NOMBRES}+" "+{ORIENTACIONES.PRIMER_APELLIDO}+" "+{ORIENTACIONES.SEGUNDO_APELLIDO}"
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 15 Aug 2008 at 12:12pm
what error are you getting? It's my guess that one of the fields returns a number and you can't concatenate this with a string. If so, use CStr(field) function to convert the number to a string.

I have the full Crystal syntax documented with tutorials in my Encyclopedia book. You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
cardpogi
Newbie
Newbie
Avatar

Joined: 07 Aug 2008
Location: Dominican Republic
Online Status: Offline
Posts: 20
Quote cardpogi Replybullet Posted: 15 Aug 2008 at 4:42pm
uhm.. actually its 3 strings, stading out to First Name, Last Name, maiden Name, i want to join all three of them. with a space between them... i really dont get any error.. it just say's it has a syntax error once i try to save...
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 16 Aug 2008 at 11:01am
I see that you have quotes at the beginning and end of the formula. Those should not be there. That makes Crystal reports get confused about the spaces separating the fields. Remove the quote at the beginning and end of the formula and see if the error goes away.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
cardpogi
Newbie
Newbie
Avatar

Joined: 07 Aug 2008
Location: Dominican Republic
Online Status: Offline
Posts: 20
Quote cardpogi Replybullet Posted: 18 Aug 2008 at 6:07am
nope.. i stil get an error.. when i try to save it says...
"There is an error in your formula. Do you want to save it anyway?"
and when i try to generate de preview, it says
"A Statment is expected here"
IP IP Logged
cardpogi
Newbie
Newbie
Avatar

Joined: 07 Aug 2008
Location: Dominican Republic
Online Status: Offline
Posts: 20
Quote cardpogi Replybullet Posted: 18 Aug 2008 at 9:22am
got it sorry was a dumb mistake on my behalf... thanks alot
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.016 seconds.