Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PRINTJOB command
Message
From
22/08/2000 12:51:33
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00407788
Message ID:
00407833
Views:
30
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform