Unanswered: Resetting a datasource - at a dialog box dead-end.
I have a Crystal Report developed using a Microsoft Access table as a sample data source.
Now I want to redirect the report to use a query into an Oracle database.
Under "Database/Set DataSource Location" I have selected the Access database as the Current Data Source and the have selected the Oracle database as the Replacement Data Source.
When I click the Update button I get this message:
"Some tables could not be replaced, as no match was found in the new data source. Please specify the table required for any unmodified tables."
The dialog box will not let me exit, but if I try specifying an Oracle table in this dialog box the Update button becomes disabled.
What the heck am I supposed to do to reset a datasource to a query?
If it's not practically useful, then it's practically useless.