Good evening, and thanks for your help!
I have contact who wants to generate a report from two different databases. One is written in FoxPro and the other is Oracle. There is a common field that would be used to link the relevant tables from each database, however in FoxPro is is formatted as text and in Oracle it is a number. Both contain a record number that appears on both systems. THe problem is that Crystal blows up because of the different field formats between these two systems. Is there any way to force this link or to create a formula (ToNumber or ToText come to mind) and use that as one of the linking fields?
Again, thanks in advance for all help!
I have contact who wants to generate a report from two different databases. One is written in FoxPro and the other is Oracle. There is a common field that would be used to link the relevant tables from each database, however in FoxPro is is formatted as text and in Oracle it is a number. Both contain a record number that appears on both systems. THe problem is that Crystal blows up because of the different field formats between these two systems. Is there any way to force this link or to create a formula (ToNumber or ToText come to mind) and use that as one of the linking fields?
Again, thanks in advance for all help!