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?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Exporting a Crystal Report to Another Formate like Excel
- Thread starter goodner
- Start date
ShankarJ
Programmer
- Aug 9, 2003
- 856
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
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
- Thread starter
- #3
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).
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- News