I've done some searching and this seems to be a common issue trying to remove lines between headers/footers and the report data. I couldn't find a solid answer in the search results I came across, but I tried SET DROPBLNKLINES = ALL and ON, neither worked. I also tried removing ON TABLE SET HTMLCSS ON and no success either.

I'm trying to output to HTML format as well. Anyone have any solutions for removing these unwanted lines? Here's my code:

TABLE FILE FOCLMCONVERSIONVERBALAPPTOWRITTEN
SUM
     COMPUTE CONVERSIONRATE/D12.2% = ( TOT.FOCLMCONVERSIONVERBALAPPTOWRITTEN.SEG01.VERBALCONVERSION / TOT.FOCLMCONVERSIONVERBALAPPTOWRITTEN.SEG01.VERBALAPP ) * 100; AS ''
     COMPUTE AVGAGECONVERSION/D12.2 = AVE.FOCLMCONVERSIONVERBALAPPTOWRITTEN.SEG01.VERBALTOWRITTENAGE; NOPRINT
FOOTING
" % Written Apps Converted "
"June 2015"
ON TABLE SUBFOOT
"<AVGAGECONVERSION <+0> <+0> "
"Avg Age of Conversion<+0> <+0> <+0>Right Metric"
" <+0> <+0> <+0> "
WHERE ( FOCLMCONVERSIONVERBALAPPTOWRITTEN.SEG01.VERBALAPPLICATIONDATE GE '20150601' ) AND ( FOCLMCONVERSIONVERBALAPPTOWRITTEN.SEG01.VERBALAPPLICATIONDATE LT '20150701' );
ON TABLE SET AUTOFIT ON
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/MidFirst_report_theme.sty,
$
     PAGECOLOR=RGB(255 102 0),
$
TYPE=REPORT,
     COLOR='WHITE',
     BACKCOLOR=RGB(255 102 0),
     CALC-LOCATION=TOP,
$
TYPE=DATA,
     COLOR='WHITE',
     BACKCOLOR=RGB(255 102 0),
$
TYPE=DATA,
     COLUMN=N1,
     SIZE=36,
     JUSTIFY=CENTER,
$
TYPE=TITLE,
     COLUMN=N1,
     SIZE=36,
     BACKCOLOR=RGB(255 102 0),
     JUSTIFY=CENTER,
$
TYPE=TABFOOTING,
     BORDER-TOP=OFF,
     BORDER-TOP-COLOR=RGB(102 102 102),
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=2,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=3,
     JUSTIFY=LEFT,
     WIDTH=3.000,
$
TYPE=TABFOOTING,
     LINE=1,
     OBJECT=FIELD,
     ITEM=1,
     SIZE=20,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=TABFOOTING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=1,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=TABFOOTING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=2,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=TABFOOTING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=3,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=TABFOOTING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=4,
     JUSTIFY=RIGHT,
     WIDTH=3.000,
$
TYPE=TABFOOTING,
     LINE=3,
     OBJECT=TEXT,
     ITEM=1,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=TABFOOTING,
     LINE=3,
     OBJECT=TEXT,
     ITEM=2,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=TABFOOTING,
     LINE=3,
     OBJECT=TEXT,
     ITEM=3,
     JUSTIFY=LEFT,
     WIDTH=1.000,
$
TYPE=TABFOOTING,
     LINE=3,
     OBJECT=TEXT,
     ITEM=4,
     JUSTIFY=LEFT,
     WIDTH=3.000,
$
TYPE=FOOTING,
     SIZE=7,
     COLOR=RGB(102 102 102),
     JUSTIFY=CENTER,
$
TYPE=FOOTING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=9,
     COLOR='WHITE',
$
TYPE=FOOTING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=9,
     COLOR='WHITE',
$
TYPE=REPORT,
     OBJECT=STATUS-AREA,
     JUSTIFY=LEFT,
     PAGE-LOCATION=TOP,
$
ENDSTYLE
END

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

I did some more digging into the stylesheets and it looks like it might have something to do with the GRID = OFF setting. When I change this to GRID = ON and also remove the lines:

TYPE=TABFOOTING,
BORDER-TOP=OFF,
BORDER-TOP-COLOR=RGB(102 102 102),
$

then the report does not have the gap between the data and the footer. However, then it has a grid around everything that I do not want either. Still trying to find a solution for this. I would ideally want the grid off and this space removed.

Have you tried commenting out the style sheet? My first thought is it's something in there causing it.

Capples,

 ON TABLE SET PAGE NOPAGE 

and use

 ON TABLE SET ACROSSLINE OFF 

 ON TABLE SET ACROSSLINE SKIP 

I guess that's pretty much there is...