Focal Point
Long list - styling

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

December 22, 2004, 04:38 PM
paw
Long list - styling
Hi,
Does anyone know any type of styling that can be done on long lists? For example, I am displaying a long list (1 column) of table entries that are drilldowns. The list can be from 500 up to 150,000+ rows - it varies. Instead of having the user scroll down through them all, I'd like to make it more presentable - i.e. maybe break out that long list into multiple columns instead of one long one. Any ideas?

Thx
December 22, 2004, 04:53 PM
susannah
If the list breaks itself naturally into groups, the ON GROUPNAME SUBHEAD would provide a natural break.
Like COUNTRY and MODEL
ON COUNTRY SUBHEAD
"<COUNTRY"

or..
present the report aggregated into those GROUPNAMES and let the user click on a GROUPNAME to get the same report for only the list values within that GROUPNAME.
or..
if you're making a dropdown list that is long,
use an <OPTGROUP LABEL= "..."> tag to break up the list.
December 22, 2004, 05:25 PM
paw
susannah - thx for the suggestion but the data really cannot be grouped. i was wondering if you can group any way by record number? so, for example, records 1 - 500 are column 1, 501 - 1000 column 2, etc.
December 22, 2004, 06:03 PM
<Pietro De Santis>
Try this row/column technique:

DEFINE FILE CAR
COL/P6 WITH MODEL = IF COL LT 4 THEN (COL + 1) ELSE 1;
ROW/P6 WITH MODEL = IF COL EQ 1 THEN (ROW + 1) ELSE ROW;
END
TABLE FILE CAR
SUM MODEL
BY ROW NOPRINT
ACROSS COL NOPRINT
END
December 22, 2004, 08:17 PM
paw
thx for the technique - worked nicely.