Report besed on 10 Access Databases

[mnasuto]

Hi,

How can I create report base on 10 different Access databasees with this same fields? I am using Crystal Report version 8.

Please help if you can.

Best,
Marta

 

[dgillz]

10 different databases or 10 different tables in the same database? Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[mnasuto]

Hi,

I have 10 different Access Databases

Best,
Marta

 

[dgillz]

You will have to add all 10 databases to your report, add the tables that you want, and then link the tables. Do you need any more info on how to do that? Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[mnasuto]

Yes please.

I trayed to do that using ODBC Access data source but then I chose first table I cannot connect to another database to get second table.

 

[dgillz]

If you are using 10 different databses you will need to create 10 different DSNs to access them. That is why I questioned if you really had 10 databases or 1 database with 10 tables.

Crystal can also read an access database natively, no ODBC drivers needed. Just point directly to the .mdb file and then pick up the table(s) you want, one database at a time. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com