Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Trouble Joining Different Data Types Post Reply Post New Topic
Author Message
SDCAHouse
Newbie
Newbie


Joined: 27 Oct 2011
Location: United States
Online Status: Offline
Posts: 1
Quote SDCAHouse Replybullet Topic: Trouble Joining Different Data Types
    Posted: 27 Oct 2011 at 10:14am
Everyone-
Good afternoon.  I have a lot of experience with Crystal Reports and a decent understanding of sql, but I am having trouble with something I've never had to do before.
 
Under the 'Database Expert', I am attempting to create a command in order to be able to join two different data types.  They are:
 
PORECLINE.REC_NUMBER_A (string)
 
and
 
MMDIST.DOC_NUMBER (number).
 
I have inputted this code:
 
Select "REC_NUMBER_A"
From "XPINST_PORECLINE" inner join MMDIST"
On "XPINST_PORECLINE"."REC_NUMBER_A" = to_number("XPINST_MMDIST"."DOC_NUMBER")
 
As I've played around with the quotation marks and apostrophes, I've gotten different errors.
 
Can anyone help me out and let me know where I'm going wrong?
 
Thanks,
 
Kyle
IP IP Logged
CircleD
Senior Member
Senior Member
Avatar

Joined: 11 Mar 2011
Location: United States
Online Status: Offline
Posts: 251
Quote CircleD Replybullet Posted: 27 Oct 2011 at 4:20pm
Try using IsNumber instead of ToNumber.
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.