August 10, 2007, 02:31 PM
jammerAdd an Underline between two rows
I do
TABLE FILE X
PRINT AMT
BY ITEM
END
and get:
ITEM AMT
A $100
B $200
C $300
D $900
I want a line between C and D like this:
ITEM AMT
A $100
B $200
C $300
-------------
D $900
Any way I can do this? (I suppose I can create another sort column field and do a noprint then do an UNDER-LINE on this sort group. - Is that the only way?)
August 10, 2007, 03:28 PM
LeahYou might look into conditional subfoot
ON ITEM SUBFOOT
"------------------------"
WHEN ITEM EQ D
August 10, 2007, 03:47 PM
tryFOCUSingI think the sort group/by field is the only way.
Example....
TYPE=SUBFOOT,
BY=1,
BORDER-BOTTOM=LIGHT,
$
August 10, 2007, 04:01 PM
GlendaLeah's idea works great too.
TABLE FILE CAR
SUM DEALER_COST
BY COUNTRY
ON COUNTRY SUBFOOT
"----------------------"
WHEN COUNTRY EQ 'FRANCE'
ON TABLE SET STYLE *
TYPE=REPORT, GRID=OFF, FONT=COURIER NEW, SIZE=10, $
ENDSTYLE
END
August 20, 2007, 02:21 PM
jammerThats it - the conditional subfoot! Thanks