Crystal Reports Active X Designer not finding SQL ODBC in subreport
Posted on 2011-09-23
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?