There is no easy way to do this directly in Crystal. However, if you can create in one database a link to the other database, you have a couple of options:
1. Create view that supplies the data from both databases in a single "table" in your report. Connect to one database and use the link to get the data from the other one.
2. In Crystal, connect to one database then create a Command in the report that uses the link to get the data from both in a single select.
Using either method, you can convert either the number to text or the text to a number in order to link the data.
-Dell
IP Logged
