Focal Point
[SOLVED] Remove blank line before subfoot

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

February 06, 2018, 11:45 AM
Joel Elscott
[SOLVED] Remove blank line before subfoot
Is it possible to remove the blank line between the report and the subfoot in this example?

  
TABLE FILE CAR
SUM
     SALES
BY CAR
ON TABLE RECAP
	TOT_SALES/D12 = SALES;
ON TABLE SUBFOOT
"Grand Total<TOT_SALES"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
TYPE=REPORT,
     BORDER-TOP=1.00,
     BORDER-BOTTOM=1.00,
     BORDER-LEFT=1.00,
     BORDER-RIGHT=1.00,
$
TYPE=DATA,
     COLUMN=N1,
     BORDER-TOP-COLOR=GREY,
     BORDER-BOTTOM-COLOR=GREY,
     BORDER-LEFT-COLOR=GREY,
     BORDER-RIGHT-COLOR=GREY,
     FONT='ARIAL',
     SIZE=10,
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N2,
     BORDER-TOP-COLOR=GREY,
     BORDER-BOTTOM-COLOR=GREY,
     BORDER-LEFT-COLOR=GREY,
     BORDER-RIGHT-COLOR=GREY,
     FONT='ARIAL',
     SIZE=10,
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N1,
     BORDER-TOP-COLOR=GREY,
     BORDER-BOTTOM-COLOR=GREY,
     BORDER-LEFT-COLOR=GREY,
     BORDER-RIGHT-COLOR=GREY,
     FONT='ARIAL',
     SIZE=10,
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N2,
     BORDER-TOP-COLOR=GREY,
     BORDER-BOTTOM-COLOR=GREY,
     BORDER-LEFT-COLOR=GREY,
     BORDER-RIGHT-COLOR=GREY,
     FONT='ARIAL',
     SIZE=10,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     BORDER-TOP-COLOR=GREY,
     BORDER-BOTTOM-COLOR=GREY,
     BORDER-LEFT-COLOR=GREY,
     BORDER-RIGHT-COLOR=GREY,
     FONT='ARIAL',
     SIZE=10,
     STYLE=BOLD,
     JUSTIFY=RIGHT,
     HEADALIGN=BODY,
$
ENDSTYLE
END

This message has been edited. Last edited by: Joel Elscott,


WebFOCUS 8.2.03
z/OS
February 06, 2018, 02:04 PM
Tom Flynn
  
DEFINE FILE CAR
  DUMMY/A1 = '';
END
TABLE FILE CAR
SUM
     SALES/P12.2C
BY DUMMY NOPRINT
BY CAR
ON DUMMY SUMMARIZE AS 'Grand Total'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
TYPE=SUBTOTAL, STYLE=BOLD, BACKCOLOR=TAN,$


TYPE=REPORT,
     BORDER-TOP=1.00,
     BORDER-BOTTOM=1.00,
     BORDER-LEFT=1.00,
     BORDER-RIGHT=1.00,
$
TYPE=DATA,
     COLUMN=N1,
     BORDER-TOP-COLOR=GREY,
     BORDER-BOTTOM-COLOR=GREY,
     BORDER-LEFT-COLOR=GREY,
     BORDER-RIGHT-COLOR=GREY,
     FONT='ARIAL',
     SIZE=10,
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N2,
     BORDER-TOP-COLOR=GREY,
     BORDER-BOTTOM-COLOR=GREY,
     BORDER-LEFT-COLOR=GREY,
     BORDER-RIGHT-COLOR=GREY,
     FONT='ARIAL',
     SIZE=10,
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N1,
     BORDER-TOP-COLOR=GREY,
     BORDER-BOTTOM-COLOR=GREY,
     BORDER-LEFT-COLOR=GREY,
     BORDER-RIGHT-COLOR=GREY,
     FONT='ARIAL',
     SIZE=10,
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N2,
     BORDER-TOP-COLOR=GREY,
     BORDER-BOTTOM-COLOR=GREY,
     BORDER-LEFT-COLOR=GREY,
     BORDER-RIGHT-COLOR=GREY,
     FONT='ARIAL',
     SIZE=10,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     BORDER-TOP-COLOR=GREY,
     BORDER-BOTTOM-COLOR=GREY,
     BORDER-LEFT-COLOR=GREY,
     BORDER-RIGHT-COLOR=GREY,
     FONT='ARIAL',
     SIZE=10,
     STYLE=BOLD,
     JUSTIFY=RIGHT,
     HEADALIGN=BODY,
$
ENDSTYLE
END
-EXIT



Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
February 06, 2018, 03:16 PM
Joel Elscott
Thanks Tom! This helps a lot. I ended up using a SUBFOOT, as I have some special formatting that's needed in my live application. Here is the final code:

  
DEFINE FILE CAR
  DUMMY/A1 = '';
END

TABLE FILE CAR
SUM
     SALES/D12
BY DUMMY NOPRINT
BY CAR
ON DUMMY RECAP
	TOT_SALES/D12 = SALES;
ON DUMMY SUBFOOT
"Grand Total<TOT_SALES"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
TYPE=REPORT,
     BORDER-TOP=1.00,
     BORDER-BOTTOM=1.00,
     BORDER-LEFT=1.00,
     BORDER-RIGHT=1.00,
$
TYPE=DATA,
     COLUMN=N1,
     BORDER-TOP-COLOR=GREY,
     BORDER-BOTTOM-COLOR=GREY,
     BORDER-LEFT-COLOR=GREY,
     BORDER-RIGHT-COLOR=GREY,
     FONT='ARIAL',
     SIZE=10,
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N2,
     BORDER-TOP-COLOR=GREY,
     BORDER-BOTTOM-COLOR=GREY,
     BORDER-LEFT-COLOR=GREY,
     BORDER-RIGHT-COLOR=GREY,
     FONT='ARIAL',
     SIZE=10,
     STYLE=NORMAL,
$
TYPE=DATA,
     COLUMN=N3,
     BORDER-TOP-COLOR=GREY,
     BORDER-BOTTOM-COLOR=GREY,
     BORDER-LEFT-COLOR=GREY,
     BORDER-RIGHT-COLOR=GREY,
     FONT='ARIAL',
     SIZE=10,
     STYLE=NORMAL,
$
TYPE=TITLE,
     COLUMN=N1,
     BORDER-TOP-COLOR=GREY,
     BORDER-BOTTOM-COLOR=GREY,
     BORDER-LEFT-COLOR=GREY,
     BORDER-RIGHT-COLOR=GREY,
     FONT='ARIAL',
     SIZE=10,
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N2,
     BORDER-TOP-COLOR=GREY,
     BORDER-BOTTOM-COLOR=GREY,
     BORDER-LEFT-COLOR=GREY,
     BORDER-RIGHT-COLOR=GREY,
     FONT='ARIAL',
     SIZE=10,
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N3,
     BORDER-TOP-COLOR=GREY,
     BORDER-BOTTOM-COLOR=GREY,
     BORDER-LEFT-COLOR=GREY,
     BORDER-RIGHT-COLOR=GREY,
     FONT='ARIAL',
     SIZE=10,
     STYLE=BOLD,
$
TYPE=SUBFOOT,
     BORDER-TOP-COLOR=GREY,
     BORDER-BOTTOM-COLOR=GREY,
     BORDER-LEFT-COLOR=GREY,
     BORDER-RIGHT-COLOR=GREY,
     FONT='ARIAL',
     SIZE=10,
     STYLE=BOLD,
     JUSTIFY=RIGHT,
     HEADALIGN=BODY,
$
ENDSTYLE
END




WebFOCUS 8.2.03
z/OS