Solved

Crystal Reports Multiple ODBC connections

Posted on 2009-07-14
2
405 Views
Last Modified: 2012-05-07
I have a report that reads data from two different ODBC connections.  I've run across a problem where the report will come up blank for two invoices.  Of the 30 invoices I have, only 2 will not print.  If I change all tables to use the same ODBC connection and move the database files into a single location then the two invoices print fine.  I can't figure out what the problem is.
0
Comment
Question by:grossman52
2 Comments
 
LVL 17

Accepted Solution

by:
pssandhu earned 500 total points
ID: 24853298
Crystal allows you to configure 2 different datasources but this is not recommened, specially when the two datasources are not linking togehter and you absolutely know it will work fine. So, having more than one datasource can produced unreliable/unexpected results.
If you can I would suggest using just one datasource.
P.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 24856358
Agree.

If you really need 2 datasources, consider using a subreport for one of the data sources.

mlmcc
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Crystal Reports CSV data source, field types 6 94
Crystal Reports get subgroup count 1 50
Crystal Reports 13 5 57
Crystal Reports 2013 25 34
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

815 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now