Hello All,

I've searched and cannot find the answer. If I want a page or report footer to be against the report itself without a space, how would I change my styling to achieve this?

I did find: SET DROPBLNKLINE=ON however it doesn't seem to drop it for us with our stylesheet. Not sure why.

http://documentation.informati...f/source/topic23.htm

  
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
PAGECOLOR=WHITE,
$
TYPE=REPORT,
BORDER=LIGHT,
BORDER-STYLE=SOLID,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
TOPGAP=0.013889,
BOTTOMGAP=0.00000,
$
TYPE=DATA,
SIZE=8,
BACKCOLOR=(RGB(189 211 222) WHITE ),
$
TYPE=TITLE,
STYLE=BOLD,
COLOR=WHITE,
BACKCOLOR=RGB(232 8 8),
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
BORDER-TOP-STYLE=OUTSET,
BORDER-BOTTOM-STYLE=OUTSET,
BORDER-LEFT-STYLE=RIDGE,
BORDER-RIGHT-STYLE=RIDGE,
BORDER-COLOR=WHITE ,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
SIZE=8,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=4,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=7,
OBJECT=TEXT,
ITEM=1,
SIZE=8,
STYLE=NORMAL,
$
TYPE=FOOTING,
BORDER=OFF,
SIZE=8,
STYLE=BOLD,
$
TYPE=FOOTING,
LINE=1,
JUSTIFY=CENTER,
$
TYPE=FOOTING,
LINE=2,
JUSTIFY=RIGHT,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=SILVER,
$
TYPE=SUBTOTAL,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
$
TYPE=ACROSSVALUE,
SIZE=8,
$
TYPE=ACROSSTITLE,
SIZE=9,
BACKCOLOR='RGB(232 8 8)',
STYLE=BOLD,
COLOR=WHITE ,
$
TYPE=GRANDTOTAL,
BORDER-TOP=MEDIUM,
BORDER-BOTTOM=MEDIUM,
BORDER-LEFT=OFF,
BORDER-RIGHT=OFF,
BORDER-TOP-STYLE=GROOVE,
BORDER-BOTTOM-STYLE=GROOVE,
BACKCOLOR=SILVER,
COLOR=BLACK,
STYLE=BOLD,
$

Thank you,

John

This message has been edited. Last edited by: <Kathryn Henning>,

Unfortunately, as soon as you start using BORDER definitions in your StyleSheet, WebFOCUS will automatically add a blank line after the HEADING and before FOOOTING and TABLE SUBFOOT, without even giving you an option to choose whether or not that's what you wanted, and SET DROPBLNKLINE does not help much either.

My suggestion would be to fake your FOOTING as a SUBFOOT on a higher level field (e.g. DUMMY in the sample code below)

DEFINE FILE CAR
DUMMY/A1 = ' ';
END
TABLE FILE CAR
PRINT CAR AND MODEL AND SEATS
BY DUMMY NOPRINT
BY COUNTRY
ON DUMMY SUBFOOT
"Dummy Footing"
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
TYPE=REPORT, BORDER=LIGHT, FONT='ARIAL',SIZE=9, $
END

Alternatively, if your report format is HTML, you can move most of your styling into classes in a CSS file and use CLASS=... in your report style to refer to those styles.

For example:

ON TABLE SET HTMLCSS OFF
ON TABLE SET CSSURL '/approot/my_app/my_stylesheet.css'
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
PAGECOLOR=WHITE,
$
TYPE=REPORT,
BORDER=LIGHT,
BORDER-STYLE=SOLID,
FONT='ARIAL',
SIZE=9,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
RIGHTGAP=0.125000,
TOPGAP=0.013889,
BOTTOMGAP=0.00000,
$
TYPE=DATA, CLASS=DATA, BACKCOLOR=(RGB(189 211 222) WHITE ),$
TYPE=TITLE, CLASS=TITLE,$
TYPE=TABHEADING, CLASS=TABHEADING,$
TYPE=TABFOOTING, CLASS=TABFOOTING,$
TYPE=HEADING, CLASS=HEADING,$
TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=2, CLASS=HEADING small,$
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=1, CLASS=HEADING small,$
TYPE=HEADING, LINE=3, OBJECT=TEXT, ITEM=1, CLASS=HEADING small,$
TYPE=GRANDTOTAL, CLASS=GRANDTOTAL,$
etc.

The CSS file then contains sections like this:

.DATA { font-size: 8pt; }
.TITLE { font-weight: bold; color: white; background-color: rgb(232,8,8); }
.HEADING { border-style: outset ridge; border-width: medium none; border-color: white; font-size: 12pt; font-weight: bold; }
etc.