?
Solved

Crystal Reports Active X Designer not finding SQL ODBC in subreport

Posted on 2011-09-23
7
Medium Priority
?
684 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 101

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 101

Expert Comment

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

mlmcc
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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 101

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 101

Accepted Solution

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

mlmcc
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
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 …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

718 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