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


Crystal Reports database linking from multiple databases

Posted on 2006-06-05
Medium Priority
Last Modified: 2008-02-20
I'm using Crystal Reports version 8.5.  I would like to know if I can link from different databases the same table to obtain my data.  For ex.  Company A and Company B each has a different ODBC name.  however table APVEN.dat is included on both companies.  I would like to take the information of both companies' tables into one report.

Please advise.
Question by:mrizo
  • 2
LVL 101

Accepted Solution

mlmcc earned 150 total points
ID: 16927230
The easiest way is to use subreports.  One for each data source.

CR8.5 cannot handle multiple data sources in a report except through the use of subreports.

If you need to have the data mixed then can you create an Access database that can link to the 2 sources?  If so you can then bring in both sources through a union query.

LVL 11

Expert Comment

ID: 16934438
Yes its true
LVL 101

Expert Comment

ID: 17142746
How is that the answer?  

If you need more specific information please ask.


Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
The advancement in technology has been a great source of betterment and empowerment for the human race, Nevertheless, this is not to say that technology doesn’t have any problems. We are bombarded with constant distractions, whether as an overload o…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

564 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