?
Solved

How Crystal Report  can access multiple database?

Posted on 2003-03-28
7
Medium Priority
?
363 Views
Last Modified: 2008-03-06
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
0
Comment
Question by:herryfz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 

Author Comment

by:herryfz
ID: 8225577
Awaiting your help
0
 

Expert Comment

by:OutsideNormal
ID: 8226583
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/reporting on the various databases.

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.

0
 
LVL 1

Expert Comment

by:DeepBlueInVB
ID: 8229434
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.
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
LVL 101

Expert Comment

by:mlmcc
ID: 8232277
0
 
LVL 17

Expert Comment

by:walterecook
ID: 10360661
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:
http://www.experts-exchange.com/help.jsp#hs5

walterecook
EE Cleanup Volunteer
0
 
LVL 17

Expert Comment

by:walterecook
ID: 10392338
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
0
 

Accepted Solution

by:
amp072397 earned 0 total points
ID: 10426224
PAQed - no points refunded (of 75)

amp
Community Support Cleanup Moderator
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question