[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.