Crystal Reports Active X Designer not finding SQL ODBC in subreport

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?
chaverlyAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
The easy way would be to just link the tables from Access

mlmcc
0
 
mlmccCommented:
IS this on the machine with Crystal installed?

mlmcc
0
 
chaverlyAuthor Commented:
Yes, but we're running it through an ERP called Profit Key. It has the Crystal Viewer.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
mlmccCommented:
Does that application support Crystal subreports?

mlmcc
0
 
chaverlyAuthor Commented:
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
 
mlmccCommented:
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
 
chaverlyAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.