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     [CLOSED] Center Alignment of table in PDF report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Center Alignment of table in PDF report
 Login/Join
 
subhash
Member
posted
Hi All,

I have this piece of code which places the table on the left side. I want this table to be placed on the center of the report. I tried using TYPE = REPORT ,JUSTIFY=CENTER , but it is placing the data in the table to center but not the table itself. I can adjust it using LEFT and RIGHT MARGINS, but it will mislead me when more columns will come into picture. So, is there a way where it can be adjusted to center of the report by itself.

Code:

-* File CENTER_ALIGNMENT.fex
TABLE FILE CAR
PRINT
'CAR.COMP.CAR'
'CAR.CARREC.MODEL'
'CAR.BODY.BODYTYPE'
HEADING
"car example"

ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=ON,
FONT='TIMES NEW ROMAN',
SIZE=10,
JUSTIFY=CENTER,
$
ENDSTYLE
END

This message has been edited. Last edited by: Kerry,
 
Posts: 17 | Registered: April 30, 2010Report This Post
Francis Mariani
Expert
posted Hide Post
I don't think there's any way to control this.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Don Garland
Guru
posted Hide Post
I'm wondering if the painter tool would work?
 
Posts: 291 | Location: Greater Cincinnati  | Registered: May 11, 2005Report This Post
Darin Lee
Virtuoso
posted Hide Post
I don't think it can be centered that way either. Using margin adjustments can "fake" it but if you add a column or two, as subhash mentions, those would need to be readjusted. The layout tool / precision report tool also provides some control at this level as well, but if the overall width of the report increases, they again would need to be adjusted.


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
njsden
Virtuoso
posted Hide Post
Not too mention that the use of SQUEEZE=ON has also an impact on the overall report width as it will depend on the actual data being presented and therefore there is no easy way to pre-set left and right margins.


Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Tom Flynn
Expert
posted Hide Post
Hi Darin,

Yea, I saw that it was tried already, so, I deleted my thought. That's the only way I know, besides spot markers, that ADOBE displays the data.

Here's what I had suggessted which Darin responded to:

UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
LEFTMARGIN=2, RIGHTMARGIN=2,
$

AND, I added:

TYPE-HEADING, JUSTIFY=CENTER,$

You could create DM & variables based on the # of columns coming through, another option...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
Waz
Expert
posted Hide Post
The only way that I can think of doing this, is to make the report "fixed", each column has its width, and the width of the report is know, then adjust the margins.

Perhaps this would be a nice NFR.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
PBax
Gold member
posted Hide Post
Could you not do a count of the number of columns then have the let margin dynamic relative to the number of columns?

i.e 5 columns - &marg=5.0
6 columns - &marg=4.0
7 columns - &marg=3.0


81.05 All formats
 
Posts: 56 | Location: Manchester | Registered: November 21, 2006Report This Post
subhash
Member
posted Hide Post
I have the columns dynamically coming......


7.6.4,unix
all output
 
Posts: 17 | Registered: April 30, 2010Report This Post
Waz
Expert
posted Hide Post
Don't forget Proportional Fonts ....


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report 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     [CLOSED] Center Alignment of table in PDF report

Copyright © 1996-2020 Information Builders