Re: Mailing Labels

["Blakeslee, Andy" <ALBlakeslee@HOMELOAN.COM>]

look up the columns command in your sqr manual - this provides the
functionality you are looking for without using arrays or having to do any
explicit looping.  If you are a PeopleSoft HR client, look at per006b.sqr
for an example.

> -----Original Message-----
> From: Everry Man [SMTP:everryman@HOTMAIL.COM]
> Sent: Monday, December 14, 1998 2:33 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Mailing Labels
>
> I am currently looking for techniques for writing an SQR that will print
> standard mailing labels. Standard Avery label sheets will be used (3
> across, 10 down). The problem is selecting people 3 at a time so that I
> can print 3 names across, then 3 street addresses across, etc. I am
> thinking about saving all people's IDs to an array, and then spinning
> through the array 3 at a time. Please advise with any techniques or code
> that might help.
>
> Thanks,
> Dan O'Donnell
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com