Only display column headings at top of data

[Former Member]

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

[Former Member · Accepted solution]

Hi Dave

You can create main report based off Access database and insert subreport based off Informix database.

You can link subreport to main report by right clicking on subreport and then on 'change subreport links' option .

Then select your common field in 'fields to link' window.

Other way is you can create parameter based off common field in subreport.

Then again go to 'change subreport links' and select that parameter in 'Subreport parameter field to use'.

Hope this helps..

Regards

Ankeet

[former_member230846]

Hi David,

You might be able to do this within Crystal Reports (Database|Database Expert) by adding the table from another datasource into the report.

Once the table has been added, go to the 'Links' tab and link the corresponding fields by dragging the field from one table to the field to link on in the other table. Right-click on the visual link that gets created, select 'Link Options' and specify the Link Type to be the 'equal sign'.

If this does not work for you, you will need to add a subreport, where the main report is based off of one table and the subreport is based off the other database table. From there you can link the subreport to the main report on a specified database field.

Regards,

Wallie