[SOLVED] Formatting For Multi-line Titles

November 29, 2017, 03:07 PM

Michael L Meagher

I would like to turn off the backcolor for the top row of each title ('The') in this example. Any ideas?

TABLE FILE CAR
PRINT
     CAR.SPECS.LENGTH AS 'The,Car,Length'
     CAR.SPECS.WIDTH AS 'The,Car,Width'
     CAR.SPECS.HEIGHT AS 'The,Car,Height'
     CAR.SPECS.WEIGHT AS 'The,Car,Weight'
BY  CAR.ORIGIN.COUNTRY AS 'Country'
BY  CAR.COMP.CAR AS 'Car'
BY  CAR.CARREC.MODEL AS 'Model'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.138889,
     RIGHTMARGIN=1.000000,
     TOPMARGIN=0.250000,
     BOTTOMMARGIN=0.000000,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=9,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$
TYPE=TITLE,
     STYLE=-UNDERLINE,
$
TYPE=TITLE,
     COLUMN=N7,
     COLOR='BLUE',
     BACKCOLOR='LIGHT GRAY',
     STYLE=BOLD+ITALIC,
$
TYPE=TITLE,
     COLUMN=N6,
     COLOR=RGB(255 102 0),
     BACKCOLOR='LIGHT GRAY',
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N5,
     COLOR='GREEN',
     BACKCOLOR='LIGHT GRAY',
     STYLE=BOLD+ITALIC,
$
TYPE=TITLE,
     COLUMN=N4,
     COLOR='RED',
     BACKCOLOR='LIGHT GRAY',
     STYLE=BOLD,
$
ENDSTYLE
END

This message has been edited. Last edited by: Michael L Meagher,

November 29, 2017, 03:33 PM

Francis Mariani

The only reliable way is to use HEADALIGN:

-* File fp_meagher1.fex

TABLE FILE CAR
PRINT
     CAR.SPECS.LENGTH AS 'Car,Length'
     CAR.SPECS.WIDTH AS 'Car,Width'
     CAR.SPECS.HEIGHT AS 'Car,Height'
     CAR.SPECS.WEIGHT AS 'Car,Weight'
	 
BY  CAR.ORIGIN.COUNTRY AS 'Country'
BY  CAR.COMP.CAR AS 'Car'
BY  CAR.CARREC.MODEL AS 'Model'

HEADING
" <+0> <+0> <+0> The <+0 The <+0 The <+0 The"

ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.138889,
     RIGHTMARGIN=1.000000,
     TOPMARGIN=0.250000,
     BOTTOMMARGIN=0.000000,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='ARIAL',
     SIZE=9,
     RIGHTGAP=0.000000,
     LEFTGAP=0.000000,
$

TYPE=HEADING, HEADALIGN=BODY, JUSTIFY=RIGHT, STYLE=BOLD, $
TYPE=HEADING, ITEM=7, COLOR=BLUE, STYLE=+ITALIC, $
TYPE=HEADING, ITEM=6, COLOR=RGB(255 102 0), $
TYPE=HEADING, ITEM=5, COLOR=GREEN, STYLE=+ITALIC, $
TYPE=HEADING, ITEM=4, COLOR=RED, $

TYPE=TITLE,
     STYLE=-UNDERLINE,
$
TYPE=TITLE,
     COLUMN=N7,
     COLOR='BLUE',
     BACKCOLOR='LIGHT GRAY',
     STYLE=BOLD+ITALIC,
$
TYPE=TITLE,
     COLUMN=N6,
     COLOR=RGB(255 102 0),
     BACKCOLOR='LIGHT GRAY',
     STYLE=BOLD,
$
TYPE=TITLE,
     COLUMN=N5,
     COLOR='GREEN',
     BACKCOLOR='LIGHT GRAY',
     STYLE=BOLD+ITALIC,
$
TYPE=TITLE,
     COLUMN=N4,
     COLOR='RED',
     BACKCOLOR='LIGHT GRAY',
     STYLE=BOLD,
$
ENDSTYLE
END