Topic: Linking tables problem Posted: 10 Sep 2009 at 8:40am
Hi All,
I'm working with Crystal X and trying to link two tables from two different Oracle databases. The field I'm linking with is a uniqe field in both tables, however, they do not share the same case. For Example: Table 1 has a record value of username1 and table 2 has a user name value of USERNAME1. Is there any way to have Crystal ignore the case or do a case conversion in the link?
Joined: 25 Sep 2009
Location: United States
Online Status: Offline
Posts: 2
Posted: 25 Sep 2009 at 12:51pm
You could create a cross-product - join the tables using fields in the linking expert in a non-sense way - such as a value that you know is 3 digits to a value that is always greater than 3 digits. Then within the Report --> Selection Formula --> records option include your actual join with the necessary case conversion.
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
IP Logged