Re: sqr page break

[data files <transmit20@HOTMAIL.COM>]

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