How Crystal Report can access multiple database?
Posted on 2003-03-28
Currently I develop an application and using Crystal Report 7.0 for all report.
This application maintain multiple company which each company has 1 database and all the database has same table/field.
As example, I have 5 database (Data01, Data02, Data03, Data04, Data05).
The report was develop using ODBC for Microsoft SQL 2000 and the report always keep connection to Data01 even from the VB programming the connection has change to Data02.
How I can switch between that database without changing the report for database connection.
I would like the switch between that database through VB programming.
Thanks in advance for your help and support