Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How Crystal Report  can access multiple database?

Posted on 2003-03-28
7
Medium Priority
?
368 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
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
Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

 
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this article, we’ll look at how to deploy ProxySQL.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

581 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