herryfz
asked on
How Crystal Report can access multiple database?
Dear Support,
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
Best Regards,
Herry Fernandez
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
Best Regards,
Herry Fernandez
You could do this by creating database links on Data01 to Data02-05 ( or any/all combinations).
After you create the links, then create a query to access data from all 5 sources. In the query you could create a field for company for sorting/filtering/reportin
Your report would then run off the created query and report on 1 or more the various companies. This would give you total control of reporting.
I'm not sure if this will resolve you issue but is a solution I've used in the same situation.
After you create the links, then create a query to access data from all 5 sources. In the query you could create a field for company for sorting/filtering/reportin
Your report would then run off the created query and report on 1 or more the various companies. This would give you total control of reporting.
I'm not sure if this will resolve you issue but is a solution I've used in the same situation.
it seems u are connecting to a database through Crystal reports.
Instead just design a report using a data definition file.
Then use VB to generate recordsets (from the various databases) and just attach those to the Report.
I am assuming that you need a separate report for each database and not a UNION across all the databases.
Instead just design a report using a data definition file.
Then use VB to generate recordsets (from the various databases) and just attach those to the Report.
I am assuming that you need a separate report for each database and not a UNION across all the databases.
This question has been classified as abandoned. I will make a recommendation to the moderators on its resolution in approximately 4 days. I would appreciate any comments by the experts that would help me in making a recommendation.
It is assumed that any participant not responding to this request is no longer interested in its final deposition.
If the asker does not know how to close the question, the options are here:
https://www.experts-exchange.com/help.jsp#hs5
walterecook
EE Cleanup Volunteer
It is assumed that any participant not responding to this request is no longer interested in its final deposition.
If the asker does not know how to close the question, the options are here:
https://www.experts-exchange.com/help.jsp#hs5
walterecook
EE Cleanup Volunteer
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:
PAQ - no points refunded
Please leave any comments here within the next four days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
walterecook
EE Cleanup Volunteer
I will leave the following recommendation for this question in the Cleanup topic area:
PAQ - no points refunded
Please leave any comments here within the next four days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
walterecook
EE Cleanup Volunteer
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER