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.
I have been trying to align the heading items with title (please see the sample code) but depending on the Data value in column; width either increases or decreases and it sets the alignment off. Is there a way to control this feature in a PDF report? Something where I could use the column number (N1, N2 etc) and set the width to a fixed size regardless of what’s in there? Also, is there a way to set GRID around line 2 & 3 in TABHEADING? I found out some info on this forum to control the size of column in a PDF file (for example LEFTGAP, BOTTOMGAP, RIGHTGAP, and TOPGAP etc) but that does not help with setting it to a fixed size. Also, some of the posts point out that the width of a column is controlled by the title. That does not seem to be case here.
In the sample, all titles are aligned with the heading items. If you change the country from England to France, the data will change and it sets the alignment off.
-* File test_fex.
TABLE FILE CAR
PRINT
DEALER_COST AS 'TITLE 4'
RETAIL_COST AS 'TITLE 5'
SALES AS 'T-6'
MODEL AS 'TITLE 7'
BY COUNTRY AS 'TITLE 1'
BY CAR AS 'TITLE 2'
BY BODYTYPE AS 'TITLE 3'
WHERE COUNTRY EQ 'ENGLAND'
ON TABLE SUBHEAD
"Test Heading for Car file"
"First 4 Columns <+0>Last 3 Columns"
"H-Country <+0>H-Car <+0>H-BType <+0>H-DCost <+0>H-RCost <+0>H-Sales <+0>H-Model "
ON TABLE SET PAGE NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=LANDSCAPE,
GRID=ON,
$
TYPE=REPORT,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
LEFTGAP=0.000000,
$
TYPE=TABHEADING, GRID=OFF, $
TYPE=TABHEADING, LINE=1, OBJECT=TEXT, SIZE=12, STYLE=BOLD,
JUSTIFY=CENTER, POSITION=3.5, $
TYPE=TABHEADING, LINE=2, OBJECT=TEXT, SIZE=10, ITEM=1, STYLE=BOLD,
JUSTIFY=LEFT, $
TYPE=TABHEADING, LINE=2, OBJECT=TEXT, SIZE=10, ITEM=2, POSITION=4.00, $
TYPE=TABHEADING, LINE=3, OBJECT=TEXT, SIZE=10, ITEM=1, STYLE=BOLD,
JUSTIFY=LEFT, $
TYPE=TABHEADING, LINE=3, OBJECT=TEXT, SIZE=10, ITEM=2, POSITION=1.00, $
TYPE=TABHEADING, LINE=3, OBJECT=TEXT, SIZE=10, ITEM=3, POSITION=1.90, $
TYPE=TABHEADING, LINE=3, OBJECT=TEXT, SIZE=10, ITEM=4, POSITION=2.70, $
TYPE=TABHEADING, LINE=3, OBJECT=TEXT, SIZE=10, ITEM=5, POSITION=3.30, $
TYPE=TABHEADING, LINE=3, OBJECT=TEXT, SIZE=10, ITEM=6, POSITION=3.90, $
TYPE=TABHEADING, LINE=3, OBJECT=TEXT, SIZE=10, ITEM=7, POSITION=4.60, $
ENDSTYLE
END
Prod: WebFOCUS 7.1.3 on Linux Kernel-2.6.5 zSeries 64bit/Apache Tomcat/5.0.28 JAVA version 1.4.2_11 server
Posts: 35 | Location: Oklahoma City | Registered: May 11, 2006
Thanks for the quick response. If I try to align it using column names, items are LEFT justified. I would check and see if I could justify it to the center of the column. Thanks again.
Prod: WebFOCUS 7.1.3 on Linux Kernel-2.6.5 zSeries 64bit/Apache Tomcat/5.0.28 JAVA version 1.4.2_11 server
Posts: 35 | Location: Oklahoma City | Registered: May 11, 2006
I think Ginny's suggestion will give you what you want. However, you do have the WIDTH= or WRAP= attributes for columns that would set columns to a fixed width. Mickey Grackin has a couple of excellent articles in the Developer Center/Tips and Techniques called WebFOCUS HTML and PDF Report Design Part I and Part II about PDF formatting that may be of some use to you.
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, 2007