Focal Point
Column Formatting

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5801068331

May 18, 2005, 07:46 PM
slfmr
Column 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
dwf
Can'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
slfmr
Thanks that helps a lot!!