Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: different databases Post Reply Post New Topic
Author Message
Libby
Newbie
Newbie
Avatar

Joined: 16 Sep 2011
Online Status: Offline
Posts: 4
Quote Libby Replybullet Topic: different databases
    Posted: 30 Nov 2011 at 6:29pm

Please help me with the following:  Linking a number field from one Excel Spreadsheet (F1) to an OBDC database string field from a different database (PR1_EmployeeMaster_EmployeeNumber).  I want to link the OBDC database employee string (example 010, 356, 624) with my excel spreadsheet number (10, 356, 624).  I am needing to join the OBDC databases department field (string,2 positions) with the excel spreadsheet's employee ID to return a result such as A30000010, C30000356, OB0000624. 

Please give me specific information....I'm pretty new at Crystal writing.
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: 30 Nov 2011 at 8:48pm
Basically you have 2 separate DB's so it can't be done.Is the information on the spreadsheet in the ODBC database somewhere?
IP IP Logged
Libby
Newbie
Newbie
Avatar

Joined: 16 Sep 2011
Online Status: Offline
Posts: 4
Quote Libby Replybullet Posted: 01 Dec 2011 at 5:58am
With the research I did, it looks like an expression or command could be done to work around these incompatibilities.  Do you know if that is possible?
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 04 Dec 2011 at 12:05pm
You should be able to query the data in two seperate command objects (the will each return a data set or table), then you can link the command objects in by the employee string. This is done in the DataLinks tab of the database expert This assumes this field exists in both and can be used to relate the command objects. They also need to be the same data type. If you need to change a data type you will need to do that in the command objects.
 
Hope this helps
 
Regards,
 
John W.
 
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.