Solved

Crystal Reports Active X Designer not finding SQL ODBC in subreport

Posted on 2011-09-23
7
677 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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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 …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

749 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