Focal Point
Add an Underline between two rows

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

August 10, 2007, 02:31 PM
jammer
Add 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?)


Webfocus 7.6.4
Windows 2003 Server, SQL Server 2005
Excel, HTML , JavaScript ,and PDF.
Reportcaster, BID, Tomcat
August 10, 2007, 03:28 PM
Leah
You might look into conditional subfoot

ON ITEM SUBFOOT
"------------------------"
WHEN ITEM EQ D


Leah
August 10, 2007, 03:47 PM
tryFOCUSing
I think the sort group/by field is the only way.

Example....
TYPE=SUBFOOT,
BY=1,
BORDER-BOTTOM=LIGHT,
$


Thanks!


WebFOCUS 7.1.4
WIN XP/SP2
August 10, 2007, 04:01 PM
Glenda
Leah'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


Glenda

In FOCUS Since 1990
Production 8.2 Windows
August 20, 2007, 02:21 PM
jammer
Thats it - the conditional subfoot! Thanks


Webfocus 7.6.4
Windows 2003 Server, SQL Server 2005
Excel, HTML , JavaScript ,and PDF.
Reportcaster, BID, Tomcat