Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Crystal Reports Active X Designer not finding SQL ODBC in subreport

Posted on 2011-09-23
7
Medium Priority
?
690 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 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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

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 …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

571 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