Print Page | Close Window

different databases

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15060
Printed Date: 22 Apr 2025 at 6:22am


Topic: different databases
Posted By: Libby
Subject: different databases
Date 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.


Replies:
Posted By: CircleD
Date 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?

Posted By: Libby
Date 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?

Posted By: jkwrpc
Date 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.
http://www.CustomReportWriters.net - www.CustomReportWriters.net
 


Print Page | Close Window