RE: [sqr-users] Bar Code Label Printing on Zebra Printers

["Knapp, Richard" <KnappR@umsystem.edu>]

Paul,

It looks as though SQR is overprinting each barcode.  New-page will add
a formfeed which may be just what you need.  New-report (with a dummy
file handle) will close the current print file.  Multiple new-reports
will close multiple open print files (progname.lis, progname_01.lis,
progname_02.lis, etc.).

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu
 

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Paul Gengler
Sent: Friday, July 16, 2004 9:43 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Bar Code Label Printing on Zebra Printers

Thanks for your response.  I'm use the call system to send the print.
I've tried "PRINT", "TYPE", and "COPY".  The one thing I did not do is
to close the output file using NEWPAGE. Just as an FYI,  let me describe
the exact problem I am having.  The only problem I seem to be having is
that the Zebra printer is not clearing memory in between each barcode
printed.  So,  the first barcode prints just fine.  The second barcode
prints the first barcode again,  and then prints the second barcode on
top of the first.  The third barcode prints the first two barcodes,  and
then prints the third barcode on top of them.  And so on . . . .   Do
you think closing the output file would correct this,  and which system
call would you use  - "PRINT", "TYPE" or "COPY"

-----Original Message-----
From: sqr-users-bounces+paul.gengler=genmills.com@sqrug.org
[mailto:sqr-users-bounces+paul.gengler=genmills.com@sqrug.org]On Behalf
Of Knapp, Richard
Sent: Friday, July 16, 2004 9:27 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Bar Code Label Printing on Zebra Printers



Hi Paul,

Does your windows job use call system to send the print job off or does
the SQR finish and then you "manually" send the windows print job off?
If the Zebra printer is always used either from windows or the handheld,
a simple way to print would be to close the output file  while the SQR
is still running (new-report for print or close # for write) then issue
a call to windows to do the printing.  This should work in batch or from
your desktop.

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Paul Gengler
Sent: Thursday, July 15, 2004 10:07 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Bar Code Label Printing on Zebra Printers


I have developed an SQR to print bar code labels on a Zebra printer.
Using Windows to file print,  and selecting the Zebra printer,  the
labels print just fine.  I'm assuming Windows is calling the printer
driver associated with the target print device, and creating a print job
in the printer language (ZPL) of the Zebra printer.  However,  now I am
attempting to execute the SQR report via a batch file from a wireless
handheld,  and directing the output file directly to the Zebra printer.
The labels are no longer printing correctly.  I'm guessing what I need
to do is to emulate what happens when I print the labels via Windows.  I
am at a total loss on how to do that ????? 


Paul Gengler
General Mills
Staff Consultant
Supply Chain IS - 16D2
(763) 293-3180
paul.gengler @ genmills.com

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users