Focal Point
Align column headings in pdf when ACROSS & OVER is used

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

June 03, 2004, 10:38 PM
<kj>
Align column headings in pdf when ACROSS &amp; OVER is used
I'm running 5.21 WebFOCUS on Windows 2000.
1) Does anyone know why the column headings(in the ex: SEATS, DEALER_COST,RETAIL_COST) are not right/centered aligned using PDF output?
2) Is there a way to center align the across values(COUNTRY & CAR values).
3) And is there a way to draw a line between each across value(in this example I want to draw a line between each country).
4) How to assign alternate background colour for each across value.

Here is the example.

TABLE FILE CAR
SUM
SEATS OVER
DEALER_COST OVER
RETAIL_COST
ACROSS COUNTRY AS ''
ACROSS CAR AS ''
ON TABLE PCHOLD FORMAT PDF
-*ON TABLE SET ONLINE-FMT HTML
ON TABLE SET PAGE-NUM OFF
ON TABLE SET EMPTYREPORT ON
ON TABLE SET ACROSSLINE OFF
ON TABLE SET STYLE *
UNITS=IN,
FONT='ARIAL',
SIZE=9,
GRID=OFF,
PAGESIZE='LETTER',
ORIENTATION=LANDSCAPE,
SQUEEZE=ON,
$
TYPE=REPORT,
FONT=ARIAL,
SIZE=9,
$
TYPE=DATA,JUSTIFY = RIGHT,FONT='ARIAL',SIZE=10,$
TYPE=TITLE,ACROSSCOLUMN=SEATS, BACKCOLOR=RGB(240 220 207), $
TYPE=TITLE,ACROSSCOLUMN=DEALER_COST, BACKCOLOR=RGB(191 216 216),$
TYPE=TITLE,ACROSSCOLUMN=RETAIL_COST, BACKCOLOR=RGB(240 220 207), $
TYPE=TITLE,STYLE=BOLD, JUSTIFY=RIGHT,$

TYPE=DATA,ACROSSCOLUMN=SEATS, BACKCOLOR=RGB(240 220 207), $
TYPE=DATA,ACROSSCOLUMN=DEALER_COST, BACKCOLOR=RGB(191 216 216),$
TYPE=DATA,ACROSSCOLUMN=RETAIL_COST, BACKCOLOR=RGB(240 220 207),$

-*TYPE=ACROSSVALUE,JUSTIFY=RIGHT,STYLE=BOLD,$
TYPE=ACROSSVALUE,ACROSS=N2,JUSTIFY=CENTER,
STYLE=BOLD,$
TYPE=ACROSSVALUE,ACROSS=N1,JUSTIFY=CENTER,
STYLE=BOLD,$
ENDSTYLE
END


Any Ideas are appreciated.

Thanks,
kj
June 11, 2004, 07:07 PM
<monte2000>
Hi KJ,

Spoke to the Product Manager and this was his response:

Actually, they ARE centered, but not the way you think. If you run the request with GRID=ON, you can see what's happening.

Here is a link to the output. You can see that each verb object creates a column. Also, the lowest level sort field IS centered over each column. However, the outer sort must exist within the matrix created by the report (since this isn't a HEADING). So, the value is centered over one of the columns. By default, it's center over the 'leftmost' of it's inner ACROSS values; if you right-justify, it will be over the right-most.

Hope this helps.

Monica