May 18, 2005, 07:46 PM
slfmrColumn Formatting
I have 1 column that I am outputting to a report and it is quite a few rows long to where it is stretching for 3 pages. Is it possible to wrap a column if it gets to the bottom of a page to create a second column right next to it starting at the top?
Does that make sense?
Thanks!!
May 18, 2005, 10:29 PM
dwfCan't think of a way to do precisely what you ask, but you could turn one column into 4 (or 40, I suppose). Something like this (where ORIG_COL is the column in question. I assumed a format of A20):
DEFINE FILE TEST
COUNTER/I2 = IF COUNTER EQ 4 THEN 1 ELSE COUNTER + 1;
COUNTER2/I7 = IF COUNTER EQ 1 THEN COUNTER2 + 1 ELSE COUNTER2;
COL1/A20 = IF COUNTER EQ 1 THEN ORIG_COL ELSE ' ';
COL2/A20 = IF COUNTER EQ 2 THEN ORIG_COL ELSE ' ';
COL3/A20 = IF COUNTER EQ 3 THEN ORIG_COL ELSE ' ';
COL4/A20 = IF COUNTER EQ 4 THEN ORIG_COL ELSE ' ';
END
TABLE FILE TEST
SUM COL1 COL2 COL3 COL4
BY COUNTER2 NOPRINT
END
Use of the IMOD function might be a bit more clever, but I can't see that it would work any better.
May 19, 2005, 07:42 PM
slfmrThanks that helps a lot!!