Your suggestion is viable since I already open the FRX at print time to set tag,tag2 and expr to empty. All additional suggestions are welcom. Therefore let me explain this issue further. I am trying to get rid of the "open the frx" operation. I have a client with 50 workstations using my software. I want to improve performance of the system and improve reliability of the system. The reports are short 1 to 2 pages at print time. The client's IS department is not experienced enough to allow DCOM. Creating a timer based print server is not an option.
Currently we:
1) Compare local copy of the report to server copy of the report
If the two are different and the server copy is newer we copy it local
2) We open the report as a table and eliminate the data as mentioned earlier. Our end users have the ability to MODIFY REPORTs to create new reports based on existing reports. This left us with the requirement to do this step every time an end user prints.
3) If we need to print multiple copies. REPORT FORM is used in a FOR ENDFOR
I have changed the code to use only server copies of the reports (FOPEN helps here). The original report is never opened with MODIFY REPORT. After a new report is created I delete the TAG,TAG2, and EXPR fields. Doing it this way allows:
1) Updating the server copy only vice updating 50 clients
2) I don't have 50 computers all storing the same reports
3) Performance is increased at print time (no copying files from server)
4) Performance is increased at print time (no opening file to delete info)
The only problem I have left is # of copies.
Terry Rooks
Software Systems Architect
Microsoft Certified Solution Developer.Net
If at first you don't succeed, then skydiving definitely isn't for you.