detail on one perforated page, and can print >1 copy of the report. They want
"customer copy" on the first page, "our copy" on the second page. Then on
the first half of the first page, then want "copy 1", and "copy 2" on the second
half. I didn't understand your original postings, is this what you do?
I base the report off a temp table, and I step through the data one row at a time.
I load 2 copies of the data into a temp table, with a "FlagColumn" set to "A" for
the first half of the page, "B" for the second half, and I break on the FlagColumn.
I load the words "copy 1" for "A" rows, "copy 2" for the "B" rows. I know exactly
how many rows of data will fit on each half, so I count the rows as I go. When
I get the max, I load "customer copy" or "our copy" into a column (I'm going on
memory on this all....).
If I have columns that might exceed the row length located, I use a series of
SGET commands within a loop to load the data into the temp table one row at
a time. The column is in the report as a fixed width font. Can you use any of this?
Karen
This might be a bit off the wall but how about a temp table with the data 3
times?
Could you count the rows/page and flag them somehow?
