You could hardcode in the SQR if the printer assignments won't change, or you could put in a lookup table if you'd rather have the flexibility to change assignments without opening up the .sqr file each time.
Bob
-----Original Message-----
From: Hallmark, Robert J [mailto:robert.j.hallmark@LMCO.COM]
Sent: Tuesday, October 19, 1999 9:24 AM
To: Multiple recipients of list SQR-USERS
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