June 03, 2004, 10:38 PM<kj>
Align column headings in pdf when ACROSS & 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
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 *
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=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),$
Any Ideas are appreciated.
June 11, 2004, 07:07 PM<monte2000>
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.