If you have to print via a file first, then you may not use my solution. I don't know why you have to do it that way, but I guess you have your reason.

In our system we have a 'print job server' which is an old PC running VFP8. The 'print job server' monitors a printjob.dbf to check for new records. If it finds a new record, the new record has info about what to print and where to print it, and then the record is flagged as done. This means that absolutely no PCs in our house print any VFP reports or labels to any printer set up on their own PC. So whenever we have to change anything at all concerning any sort of print job, like reports and labels, only the 'print job server' must be re-configured or have new software. This also means that no PC will be busy writing reports of any kind, all that is taken care of by the 'print job server'. So the 'print job server' is the only PC which ever sends anything to the printer queues. The real printer server is another computer running Windows 2000 Server, and all printers and printer queues are managed by that server.


>OK I am sorry, I may not understand who you do that!
>
>Let say I want to use the same FRX to generate 1 page from tray1 and next page on tray2
>next one on tray1 etc. and I print to a file myfile.prn and I am using PrintFile utility to print that file on a network printer because here we have operator running printer and we never send the file directly to the printer spooler.
>
>Sample program:
>
>select Report.dbf
>go top
>do while .T.
> if eof()
> exit
> endif
>
> set printer to "myprintername Tray1"
> Report Form MyReport Next 1 To Myfile.prn
> skip
>
> set printer to "myprintername Tray2"
> Report Form MyReport Next 1 To Myfile.prn
> skip
> loop
>enddo
>
>What you do to print all in the same Myfile.prn file?
>
>
>>I still don't understand what is the problem? I also print thousands of invoices and >other papers per day, and we never have any problem with the papers getting out of >sync, if that is your problem. In some situations we use the same FRX to report to >different papers taken from different paper trays. In our system we have a HP5SIMX >with four paper trays. We have a WIN2K server set up as a printer server, and it takes >care of the queues. No problemo!