Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tray selection
Message
From
07/12/2004 11:36:29
 
 
To
07/12/2004 11:02:06
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00967459
Message ID:
00967512
Views:
5
>with my suggestion you don't do anything special to print from the correct tray, no >tray info in the report file and no special functions are required. The clue is to >install the same printer many times and use different names. Then you configure >these 'virtual' printers with different trays using the Windows Printer settings.

Yes you right!
Let figure out for example if I want to process 50,000 statements and one field name tray have the number 1,2,3 or 4 for selecting the right tray and each tray have a special form preprint and color with different credit card ect., what will be the process to generate only one spool file or print to a file.prn.
Maybe you have the solution I am thinking too much.

EXP:
select myTable
scan
do case
case myTable.tray = 1
store sortkey to msort
set printer to name Prntray1
REPORT FORM myreport.frx for sortkey = msort while sortkey =msort TO FILE myReport.prn NOCONSOLE

case myTable.tray = 2
store sortkey to msort
set printer to name Prntray2
REPORT FORM myreport.frx for sortkey = msort while sortkey =msort TO FILE myReport.prn NOCONSOLE

case myTable.tray = 3
store sortkey to msort
set printer to name Prntray3
REPORT FORM myreport.frx for sortkey = msort while sortkey =msort TO FILE myReport.prn NOCONSOLE

case myTable.tray = 4
store sortkey to msort
set printer to name Prntray4
REPORT FORM myreport.frx for sortkey = msort while sortkey =msort TO FILE myReport.prn NOCONSOLE

encase

endscan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform