Skip to Content
0
Former Member
Sep 03, 2008 at 03:25 PM

Only display column headings at top of data

16 Views

Hi,

I want to pull data from two totally different databases. One is an Access DB and the other is an Informix DB. There are no common fields to link together in the Database Expert, however in the Informix DB there are some agent numbers. These agent numbers relate to a field called eOriginator in the Access DB...as shown below..

Informix database

Field

Agent number = 1364 (which is Joe Bloggs)

Access Database

Field

eOriginator = Joe Bloggs

Is there a way of telling Crystal Reports XI that Agent Number in Informix DB is the same as eOriginator in the Access DB? Basically i want to link Agent 1364 to eOriginator (both of which are equal to Joe Bloggs)

any ideas?

thanks

Dave