Solved

Crystal Reports Active X Designer not finding SQL ODBC in subreport

Posted on 2011-09-23
7
673 Views
Last Modified: 2012-05-12
Earlier this week, I put out a question about combining DataSources in Crystal XI for an Oracle database and a SQL database.  I changed the report design and used the Oracle ODBC for the main report and the SQL Server ODBC to bring the table Inventory_Map into the subreport. I then used shared variables to pass the calculations from the Sub to the Main.  Worked great. Now we are running it through a Crystal Reports Viewer and it is blowing up with the following error:

Error code at invocation of location 80020009
Source: Crystal Reports Active X Designer
Error Description : The table Inventory_Map could not be found.

Press OK to terminate your application.  Help?
0
Comment
Question by:chaverly
  • 4
  • 3
7 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 36590351
IS this on the machine with Crystal installed?

mlmcc
0
 

Author Comment

by:chaverly
ID: 36590513
Yes, but we're running it through an ERP called Profit Key. It has the Crystal Viewer.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 36591170
Does that application support Crystal subreports?

mlmcc
0
Gigs: Get Your Project Delivered by an Expert

Select from 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.

 

Author Comment

by:chaverly
ID: 36598911
Yes, it does.  We have over 50 examples and all are working.  We have never combined a SQL database and an Oracle database before.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 36599413
I don't know unless the application can't handle 2 data sources.

Does it handle reports written using one source for both SQL and Oracle databases?

mlmcc
0
 

Author Comment

by:chaverly
ID: 36599686
Good idea. I checked and it will not run it for the SQL ODBC at all.  I get the same error. How could I easily convert the SQL to Access?  I'm sure this will work.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 36599982
The easy way would be to just link the tables from Access

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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 …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
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…

813 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

19 Experts available now in Live!

Get 1:1 Help Now