Re: sqr page break

["Schutz, Jay" <schutzj@TOYSRUS.COM>]

How would you get a .lis file into excel anyway?  I have excel97 SR-2, and I
can't get a .lis file in there.

                      Thanks,
                          Jay R Schutz
Toys "R" Us - HR Systems
(201)986-8546
SchutzJ@toysrus.com
"C code...C code run...Run, code, RUN!"

> -----Original Message-----
> From: data files [SMTP:transmit20@HOTMAIL.COM]
> Sent: Monday, January 03, 2000 12:44 PM
> To:   SQR-USERS@list.iex.net
> Subject:      Re: sqr page break
>
> Brad,
>
> Just a thought - If you wrote the report to a flat file, instead of a .lis
> file, you would have more control over the formatting.
>
> To accomplish, put this in your main procedure:
>
> open c:\temp\myfile.txt as 1
> for-writing
> record=200   !this line declares the max width of the file
>
> Then, in your procedure where you would type:
> print $variable1 (,1,20)
> print $variable2 (,25,10)
>
> instead type:
> let $spacer = 5
> write 1 from $variable1:20
> write 1 from $spacer:5
> write 1 from $variable2:10
>
> This will print $variable1 starting at position 1 for a length of 20, skip
> 5
> spaces, then $variable2 starting at position 25 for a length of 10.  Each
> time the system goes through the select loop, it automatically drops down
> one line.
>
> Melissia
> ----------------------
> Melissia D. Dembrosky
> Technical Consultant
> MBH Consulting
> 770-998-2323
>
>
> >From: Brad Blake <bblake@SANDMONK.COM>
> >Reply-To: sqr-users@list.iex.net
> >To: SQR-USERS@list.iex.net
> >Subject: sqr page break
> >Date: Mon, 3 Jan 2000 10:17:05 -0700
> >
> >I am trying to write a report that the client will end up importing into
> >Excel, so it needs to have no page breaks, and no headers.  to eliminate
> >the
> >page breaks, I used the following:
> >
> >declare-layout default
> >formfeed=no
> >bottom-margin=0
> >top-margin=0
> >orientation=landscape
> >end-declare
> >
> >This eliminates the page breaks, but in viewing the output .lis file,
> there
> >is still one blank line inserted between each page.  How do I eliminate
> >this??
> >
> >Thanks in advance-
> >Brad Blake
> >bblake@sandmonk.com
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com