Multiple SQLBase database access ??

[delsdba]

Hi,

Can anybody suggest how to query a number of SQLBase databases on 1 report.


We have a patient management system which requires a database for each site, consequently I have data in 25 databases which I need to query.

I pressume I would have a report with some form of subreport which is displayed per database.

Can someone suggest how best to do this with regards to data access??


Do I need to create a Crystal Query for each database or can I implement the data access/connection in code / functions ??


Any pointers would be greatly appreciated, thanks

Dels

 

[IdoMillet]

If you can link across databases in SQLBase (if not you can do this from MS Access via ODBC) then you can use a single UNION query to combine the data from multiple sites into a single data set.

hth,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com