December 22, 2004, 04:38 PM
pawLong 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
susannahIf 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
pawsusannah - 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
pawthx for the technique - worked nicely.