Re: Lets Talk about Overlays -- MIDRANGE-L

Alan,

We use one program to print both orientations depending on the design of the overlay. Within the program, we use the following code to do the OVRPRTF command. Our overlays have been created using Excel as well.

#cmdfld = 'ovrprtf file(tislsrinv) ' +
'outq(' +
%trim(@PrtName) +
') ' +
'usrdta(POSINVOICE)';

// if page orientation = (L)andscape process page rotation

if impgornt = 'L';
#cmdfld = %trim(#cmdfld) +
' PAGRTT(90)';
endif;

#cmdlen = %len(#cmdfld);

monitor;
#cmdexec(#cmdfld:#cmdlen);
on-error;
endmon;

To output the overlay, we use the following lines. We store the overlay name in a field called imovrlay.

chkoverlay = imovrlay;
write overlayr;

In the printer file, we have the following coding.

A R OVERLAYR
A*
A OVERLAY(*LIBL/&CHKOVERLAY 0 0)
A*
A CHKOVERLAY 8A P

I hope that helps.

Nick Mart

----- Original Message ----- From: "Alan Shore" <AlanShore@xxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, December 04, 2008 8:48 AM
Subject: Re: Lets Talk about Overlays

Hi James
thanks for your reply
It looks like I didn't explain my predicament clearly
My program produces a report in landscape format, which I can print.
I have created an overlay (via Microsoft Excel 2002), unfortunately in
portrait format.
This was uploaded to the AS/400 via a certain procedure.
The same program was run with the same data, this time applying my overlay
in the OVRPRTF command
This report was then printed to the same printer.
This is where I realized the mistake I made where the overlay was in the
wrong format.
I recreated the overlay (again using Microsoft 2002) this time in landscape
format.
I uploaded the new version (as a different name) to the AS/400, re-ran the
same program with the same data applying the new overlay in the OVRPRTF.
I cannot get the new spool file to print to the same printer, no matter
what I try. The status goes to PND.
If anyone can point out what I am doing wrong, it would be much appreciated

Thanks in advance

Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

midrange-l-bounces@xxxxxxxxxxxx wrote on 12/03/2008 05:56:14 PM:

Alan, 2 things to check -

The spoolfile needs to be of type *AFPDS & you may need to mess with
the rotation

Also, the printer needs to use host print transform.

See if this will get it going.

If not, you may need to look at the spool job (if the writer ends)
to help determine the problem.

Thanks.

James Salter
American Cast Iron Pipe Company.

message: 7
date: Wed, 3 Dec 2008 16:45:50 -0500
from: Alan Shore <AlanShore@xxxxxxxx>
subject: Lets talk about Overlays

Afternoon everyone
I asked about overlays a couple of months ago, but I had to shelve that
project for a while.
However, I've been asked to open the project again
My problem is that I can download a spreadsheet (created in portrait
format) to the AS/400 and use it as an overlay.
However, the spreadsheet needs to be in landscape format, so when I save
the same spreadsheet as landscape, and download the new version (as a
different name) and use this new overlay, I cannot get the spool file to
print. It just sits in PND status.
If anyone has any ideas, or can point me in the (hopefully) right
direction, it would be MUCH appreciated

Thanks in advance

Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill

_________Confidentiality Notice_______________________
This e-mail and any files transmitted with it is
confidential and is intended solely for the use of
the individual(s) or entity(ies) to whom this e-mail
is addressed. If you are not the intended recipient
or the person responsible for delivering the e-mail
to the intended recipient, be advised that you have
received this e-mail in error, and that any use,
disclosure, dissemination, forwarding, printing,
retention or copying of this e-mail is strictly
prohibited. If you have received this e-mail in
error, please immediately return this e-mail to
the sender and delete the e-mail from your system.
Thank you.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--------------------------------------------------------------------------------

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.9.13/1827 - Release Date: 12/3/2008 5:41 PM