Exporting a Crystal Report to Another Formate like Excel

[goodner]

Still running Clarion 5b with Pervasive transactional processing for the data files. Also have two interfaces to Crystal Reports - both the older OCX and also the newer RDC. Recently have found (using either OCX or RDC) that on some workstations if a user selects to export a Crystal Report to another format (like PDF, Excel, etc.,..) when control is returned to the Clarion program some of the data files that were open at the time the report was generated are locked to the user (status 5 is returned). In order to gain access to the file they must exit the calling EXE and then load it again. If they do not export the Crystal Report but simply print the report all works fine. Any ideas?

 

[ShankarJ]

Hi!

Since the tables being open in your application has got no impact on the crystal report accessing the data for the report, why don't you just close all tables before calling the report and re-open them after the report is finished. Since C5b does not do true preemptive threading, calling the report in a separate thread would not help you although it will if you can upgrade to C6/C7.

Regards

 

[goodner]

I have already attempted to close all tables before the call to Crystal and then reopen them after control is returned from Crystal. The problem is not that the file is closed. I am able to open the file but when attempting to access a record in the file (or any file) I get a status 5 - access denied. The calling EXE must be unloaded and then call the EXE again. At this point all is fine. Again this only occurs if the Crystal Report is exported to another format (like Excel or PDF).

 

[ShankarJ]

Hi!

I do not use Pervasive so I cannot give you more help, but it might help to use and utility like File Monitor from sysinternals.com to identify if the files/tables are still in use after the export has been done.

Regards

 

[goodner]

Thanks for the tip - a good idea! Pervasive has a "Monitor" utility that does the same function - will try later today and see what I find.