Re: Automatically Route Reports to Different Printers Based on Variab le

[Diwakar Bhatt <diwakar.v.bhatt@AC.COM>]

Under unix, your simplest option is to create a print file using a naming
convention such as xxx_cccc.lis where cccc is the cost center. Send the report
file to a server. Your unix techies can write a script to periodically scan the
output directory for files produced by your program and then copy it to the
appropriate printer based on a table lookup for center versus printer.


"Hallmark, Robert J" <robert.j.hallmark@LMCO.COM> (Mailed by: "Hallmark, Robert
J" <robert.j.hallmark@LMCO.COM>)
10/19/99 01:24 PM GMT
Please respond to SQR-USERS@list.iex.net

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Diwakar V. Bhatt)
Subject:  Automatically Route Reports to Different Printers Based on Variab
      le




We have a report which is run approximately 200 times per day and generates
a work order for various tasks throughout our facility. Each work order
generated goes out to one of 10 different printers depending upon the cost
center (which is one of the report variables).  Can the SQR report be coded
to automatically select and print to the appropriate printer based on the
cost center variable.
We are using SQR Server version 4 and Oracle 8.

Any clues on how we can accomplish this would be greatly appreciated.

Thanks

Bob Hallmark