Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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

Read-Only Read-Only Topic
Go
Search
Notify
Tools
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
 
Report 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
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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-2020 Information Builders