Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Align column headings in pdf when ACROSS & OVER is used
Go
New
Search
Notify
Tools
Reply
  
Align column headings in pdf when ACROSS & OVER is used
 Login/Join
 
<kj>
posted
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
 
Reply With QuoteReport This Post
<monte2000>
posted
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
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Align column headings in pdf when ACROSS &amp; OVER is used

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.