Re: Automatically Route Reports to Different Printers Based on Va riab le

["Gayle.Hook" <Gayle.Hook@YELLOWCORP.COM>]

A good book is "SQR in PeopleSoft and Other Applications" by Galina & Vlad
Landres.
ISBN #1-884777-77-5.  You can buy it from www.amazon.com
It has many pieces of code, that have been helpful to me.

Gayle Hook

-----Original Message-----
From: Hallmark, Robert J [mailto:robert.j.hallmark@LMCO.COM]
Sent: Tuesday, October 19, 1999 10:47 AM
To: Multiple recipients of list SQR-USERS
Subject: Re: Automatically Route Reports to Different Printers Based on
Va riab le


Thanks to all for the replies.
We are using an NT Server.
I have searched the available text books and have not been successful at
finding any instructions for hardcoding the printer assignments or issuing
the commands with "Call System Using".  Any sample coding,  ideas on which
manuals might contain instructions, or any other help would be appreciated.

Note:  If designating the printer based on a variable is too complicated, I
could generate a separate report for each cost center and designate each
report to print to the appropriate printer, but I am still in the dark as to
how to code the report to select the specific printer. In that scenario, I
could use a BAT file to run the print job to the appropriate printer but I
would like to avoid that if possible.

Thanks Again

Bob Hallmark




     Ray Onko Replied:

        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

Bob Buford Replied:

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



        Can an 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/