I need to remove gap from the top and bottom of the subhead data set in PDF Report(WEB Focus 7.6.9).
(e.g just for reference)

 
TABLE FILE CAR
BY CTR NOPRINT
ON CTR SUBHEAD
"<NAME<+0>MODEL"
"<SIZE<+0>"
"_____________"
END

Gap appears after every Data set at the top and bottom.(By CTR)

This message has been edited. Last edited by: Kerry,

One solution is to use TOPGAP or BOTTOMGAP settings in a StyleSheet and experiment with negative values for gap to achieve the desired vertical spacing:

TABLE FILE CAR
BY COUNTRY NOPRINT
BY CAR NOPRINT
ON CAR SUBHEAD
"<COUNTRY <CAR"
" "
"<MODEL"
"_____________"
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
TYPE=SUBHEAD, BOTTOMGAP=-.1, $
ENDSTYLE
END

Be careful of negative gaps with things like Grids or background colours. I have seen it do weird things.

using negative value does not work it reduces space between first and second line of data but i need to reduce space below and above one set of date not every data line, just below and after "____________".

Hi Subbu,

The following code may be of help:

TABLE FILE CAR
-*"_____________"
PRINT
     'CAR.COMP.CAR'
BY 'CAR.COMP.CAR' NOPRINT

ON CAR.COMP.CAR SUBHEAD
"<CAR MODEL"
"<BODY"
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
$
TYPE=SUBHEAD,
     BY=1,
     LINE=2,
     OBJECT=FIELD,
     ITEM=1,
     STYLE=UNDERLINE,
$
ENDSTYLE
END

The output would look like this:
PAGE 1
CAR
ALFA ROMEO MODEL
SEDAN
ALFA ROMEO
ALFA ROMEO
ALFA ROMEO
AUDI MODEL
SEDAN
AUDI
BMW MODEL
SEDAN
BMW
BMW
BMW
BMW

Cheers,

Kerry

So, basically: don't use HEADING / FOOTING, use SUBHEAD / SUBFOOT on predefined sortable fields.