I want to use Crystal Reports 7.0 Pro as the Report End for my VFP6.0 Application. The problem I'm having is that Crystal doesn't like the FoxPro Tables after being modified with SDT, specifically after creating an Index via SDT.
These are the errors I get when trying to select a table into Crystal Reports:
IDAPI Error: Invalid Index Descriptor
and..
Configuration Error.
Library "pdbbtrv.dll" cannot be opened. Please check its configuration.
There are a couple of "Work-arounds" I've come up with;
Using a SELECT statement in code to select the desired data into a temporary, (non-SDT adjusted), table or I could use ODBC to access the Tables.
The Problems with these methods are.. Using the Select Method is fine for generating the reports in code, but then if I or an End User want to open the Report(s) in Crystal, it won't find the Data Source. And I don't want my End Users to have to setup ODBC Connections.
Help!
Aaron Young
Red Wing Software, Inc.