Focal Point
[Closed] Justify column titles beneath ACROSS column

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

January 17, 2012, 03:22 AM
MichaelBalle
[Closed] Justify column titles beneath ACROSS column
Trying to center the titles of the datacolums beneath the across column MODEL shows the first titles (for DEALER_COST and RETAIL_COST) centered the remaining column tiltes are shown right justified (try the code).

Any idea?


TABLE FILE CAR
SUM
DEALER_COST AS 'D'
RETAIL_COST AS 'R'
BY COUNTRY
BY CAR
ACROSS MODEL AS ''
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
UNITS=CM, SQUEEZE=ON,
$
TYPE=REPORT,
BORDER=0.5, BORDER-COLOR=BLACK,
$
TYPE=TITLE, COLUMN=DEALER_COST,
JUSTIFY=CENTER,
$
TYPE=TITLE, COLUMN=RETAIL_COST,
JUSTIFY=CENTER,
$
TYPE=ACROSSVALUE, ACROSS=MODEL,
JUSTIFY=CENTER,
$
ENDSTYLE
END

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


WebFOCUS 7.6, 7.7
Windows, All Output formats
January 17, 2012, 05:26 AM
atturhari
Here you go enjoy!

TABLE FILE CAR
SUM
DEALER_COST AS 'D'
RETAIL_COST AS 'R'
BY COUNTRY
BY CAR
ACROSS MODEL AS ''
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
UNITS=CM, SQUEEZE=ON,
$
TYPE=REPORT,
BORDER=0.5, BORDER-COLOR=BLACK,
$
TYPE=TITLE, COLUMN=DEALER_COST(*),
JUSTIFY=CENTER,
$
TYPE=TITLE, COLUMN=RETAIL_COST(*),
JUSTIFY=CENTER,
$
TYPE=ACROSSVALUE, ACROSS=MODEL,
JUSTIFY=CENTER,
$
ENDSTYLE
END


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
January 17, 2012, 10:17 AM
MichaelBalle
Thanks for your support - the solution works fine.


WebFOCUS 7.6, 7.7
Windows, All Output formats