Solved

Crystal Reports Active X Designer not finding SQL ODBC in subreport

Posted on 2011-09-23
7
669 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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. …
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…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

910 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

20 Experts available now in Live!

Get 1:1 Help Now