>Has anyone figured out ANY routine for ANY printer where the different copies can be fired to a different paper tray on the printer? (Would need a multi-trayed printer, obviously). We're ready to require a specific printer-- if the solution can be found.
>

Our users can print multiple copies of an invoice to different trays on the same printer. In the default settings of our App our customers define how many copies they want printed and have to tell the system what the Tray Code is for every copy.

When it comes to printing the Invoice report we do the following:

1. make a local copy of the Invoice report (FRX and FRT files)
2. open the report as a table
3. look for the entry DEFAULTSOURCE=NN in the EXPR field
4. use STUFF() to replace DEFAULTSOURCE=NN with DEFAULTSOURCE=XX, where
XX is the tray code number for the copy to be printed
5. close table and print
6. Loop 2-5 for every copy to be printed.

It works well for us. The only challenge is to know what the Tray Codes are for every printer manufacturer and model. Fortunately there's really only a handful of printer brands that are in common use.

For instance, with HP printers, use tray code 7 for tray #1, and tray code 11 for tray #2.

Note that step 1 is important - you don't really want to edit the original report format across a network when another user on the network also wants to print an invoice.

regards,

Alain Legrand