Focal Point
Title changes font

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

May 24, 2005, 03:55 PM
Håkan
Title changes font
I've got this piece of code:

TABLE FILE filename
SUM D_OB_TOT_NET_VAL AS 'OB Tot Net �'
D_OB_TOT_NET_UNS AS 'OB Tot Net (n)'
D_CO_TOT_NET_VAL AS 'Co Tot Net �'
D_CO_TOT_NET_UNS AS 'Co Tot Net (n)'
BY FRANCHISEE_CONCAT AS 'Franchisee'
BY D_BRAND_CONCAT AS 'Brand'
BY BRANCH_CONCAT AS 'Branch'
ACROSS DAY NOPRINT
ACROSS D_DAY_NAME AS ''
ACROSS D_DATE3 AS ''
ON TABLE SET HTMLCSS ON
.
.
END

What happens is that the first page is ok, but as of page 2 and onwards, the last 3 column titles change from bold Ariel 8 pts to normal Times New Roman 11 pts. If I remove the HTMLCSS it works ok. Also if I only sum 1 column across the week, it works. To me it sounds lika a bug, but I thought I post a query here first.

We're on WF 5.2.7 on IBM iSeries.
May 24, 2005, 04:22 PM
reFOCUSing
Can you post the style sheet you are using? I had something like this happen to me and it was because I was aligning the title and for some reason it over-wrote the settings.
May 25, 2005, 10:30 AM
Håkan
Curtis, here it is:

-DEFAULT &REDNEGS = 'Y'

UNITS=IN,
PAGESIZE='SCREEN',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
ORIENTATION=LANDSCAPE,
$
DEFMACRO=COND0001,
MACTYPE=RULE,
WHEN=N6 LT 10000,
$
TYPE=REPORT,
BORDER=LIGHT,
BORDER-COLOR='SILVER',
FONT='ARIAL',
SIZE=8,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
TOPGAP=0.013889,
BOTTOMGAP=0.027778,
JUSTIFY=LEFT,
SQUEEZE=ON,
$
TYPE=DATA,
SIZE=8,
BACKCOLOR=( RGB(235 235 235) RGB(255 255 255) ),
$ BACKCOLOR=( RGB(250 250 250) RGB(255 255 255) ),
$ BACKCOLOR=( RGB(255 255 210) RGB(255 255 255) ),
$
TYPE=DATA,
COLUMN=C*,
JUSTIFY=RIGHT,STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=B*,
STYLE=NORMAL,
$
TYPE=SUBTOTAL,
COLUMN=C*,
JUSTIFY=RIGHT,
$
TYPE=GRANDTOTAL,
COLUMN=C*,
JUSTIFY=RIGHT,
$

TYPE=TITLE,
BORDER-COLOR=RGB(127 127 127),
COLOR=RGB(0 0 0),
$ BACKCOLOR=RGB(255 203 105),
$ BACKCOLOR=RGB(201 218 232),
BACKCOLOR=RGB(255 255 255),
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=10,
COLOR='NAVY',
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=10,
COLOR='NAVY',
STYLE=BOLD,
$
TYPE=HEADING,
BORDER=LIGHT,
BORDER-COLOR=RGB(127 127 127),
SIZE=10,
COLOR=RGB(64 128 128),
BACKCOLOR=RGB(255 255 255),
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
SIZE=12,
$
TYPE=FOOTING,
-* LINE=1,
BORDER=LIGHT,
BORDER-COLOR=RGB(127 127 127),
SIZE=8,
-* COLOR=RGB(170 0 0),
COLOR=RGB(64 128 128),
BACKCOLOR=RGB(250 250 250),
STYLE=BOLD,
$
TYPE=TABFOOTING,
LINE=1,
COLOR=RED,
FOCEXEC=app/agusend.fex(OUTPUT='&SEL_OUTPUT..' EFILE='&AG_APPEXEC..' DOMAIN='&AG_DOMAIN..' T='&TOD..'),
$
$ FOCEXEC=app/agusend.fex(OUTPUT='&SEL_OUTPUT..' EFILE='&AG_APPEXEC..' T='&TOD..'),
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=8,
STYLE=BOLD,


$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(232 232 232),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
TYPE=DATA,COLUMN=ROWTOTAL,JUSTIFY=RIGHT,$
TYPE=SUBTOTAL,COLUMN=ROWTOTAL,JUSTIFY=RIGHT,$
TYPE=GRANDTOTAL,COLUMN=ROWTOTAL,JUSTIFY=RIGHT,$

-IF &REDNEGS NE 'Y' GOTO :negsdone;
-INCLUDE AGU_REDNEGS
-:negsdone

The agu_rednegs is for viewing negative values in red, which is not applicable for the entire organisation. It basically contains this:

TYPE=DATA, COLUMN=C01, WHEN=C01 LT 0, JUSTIFY=RIGHT, COLOR=RED, $