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

[Ray Ontko <rayo@ONTKO.COM>]

Bob,

Are you running on a Unix server, NT, or some other operating system?

A typical approach would be to have the SQR program kick off the
print job after looking up the print queue information for the
cost center.  To do this, you would need to use NEW-REPORT ''
end the report you're currently generating, then CALL SYSTEM
to issue the command(s) to print the output file to the desired
printer.  This may be easier to do under Unix than NT.

Ray

> 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
>

----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/