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     <TABPAGENO OF <TABLASTPAGE as one item in PDF

Read-Only Read-Only Topic
Go
Search
Notify
Tools
<TABPAGENO OF <TABLASTPAGE as one item in PDF
 Login/Join
 
henry_ma@agsea.com
Member
posted
I'm creating a PDF report that needs to have a "Page: 1 of 1" in the header. I can't find a way to trick WebFOCUS to POSITION "<TABPAGENO of <TABLASTPAGE" to fall under "ITEM3". Any ideas?

Here is my CAR file where the "Page: 1 of 1" doesn't all fall under ITEM3:
TABLE FILE CAR
HEADING
"ITEM1 <+0>ITEM2 <+0>ITEM3"
"ONE <+0>TWO <+0>Page: <TABPAGENO of <TABLASTPAGE"
SUM BODY.SALES/D11.2M AS 'BODY SALES'
BY CARREC.MODEL AS 'CARREC MODEL'
BY COMP.CAR AS 'COMP CAR'
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='SCREEN',
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=HEADING, STYLE=BOLD, HEADALIGN=INTERNAL, $
TYPE=HEADING, ITEM=1, JUSTIFY=LEFT,POSITION=P1, $
TYPE=HEADING, ITEM=2, JUSTIFY=CENTER,POSITION=P2, $
TYPE=HEADING, ITEM=3, JUSTIFY=RIGHT,POSITION=P3, $
TYPE=REPORT, HEADALIGN=INTERNAL, $
ENDSTYLE
END

Thanks!

This message has been edited. Last edited by: henry_ma@agsea.com,


------------------------------------------------------
WebFocus 7.1.6
Web Server: resides on MS IIS with Tomcat plug-ins on Windows 2003 SPI
SQL database: Informix Client-SDK Version 2.70
IE version 6.0
 
Posts: 4 | Registered: January 17, 2007Report This Post
FrankDutch
Virtuoso
posted Hide Post
Henry

do I understand you well if this is what you want

item1              item2                                   item3
one                two                              page: 1 of 5

model              car                              sales
-----              ------                           ------
Break              Mercedes                         6.000
etc


If this is what you want the code you used should work, but the only line I would remove is:
ON TABLE SET PAGE-NUM OFF

you have to play a bit with the positioning with the grid settings.

BTW update your signature, the version you use might be important.




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
henry_ma@agsea.com
Member
posted Hide Post
Frank,

My problem is the POSITITIONing. I removed the "ON TABLE SET PAGE-NUM OFF", but it's still not all POSITIONED under ITEM3. The "Page: " is showing up under ITEM3. The "1 of" starts after ITEM3 ends and the "1" is way off to the right somewhere...

This message has been edited. Last edited by: henry_ma@agsea.com,


------------------------------------------------------
WebFocus 7.1.6
Web Server: resides on MS IIS with Tomcat plug-ins on Windows 2003 SPI
SQL database: Informix Client-SDK Version 2.70
IE version 6.0
 
Posts: 4 | Registered: January 17, 2007Report This Post
susannah
Expert
posted Hide Post
henry, you probably want to read the 2 articles by mickey gracking on pdfs which you get to from the FP home page, on the left nav panel, click on 'tips and techniques' (what used to be called Focus on Developers) where developers write detailed articles on subjects of interest.
mickey talks about positioning there.



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
ihf
Member
posted Hide Post
ok my output shows (i used country as my first sort)...

ITEM3
Page: 1 of 5
BODY SALES
----------
$12,000

THE 1 OF 5 IS FAIRLY CLOSE TO THRE WORD 'PAGE:' WHERE EXACTLY DO YOU WANT IT TO APPEAR?

Ira

WF 5.3.6 AIX
 
Posts: 29 | Registered: March 30, 2007Report This Post
Francis Mariani
Expert
posted Hide Post
Ira,

If you look at the PDF version of the report created by the code above, it looks like this:



Item three of the heading is "Page: " not the whole "Page: 1 of 1", so "Page: " is right aligned to the third column of the report. "1 of 1" (five digits reserved for each of the two numeric fields) comes after - not a pretty sight. Mickey most likely has a solution for that.


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
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     <TABPAGENO OF <TABLASTPAGE as one item in PDF

Copyright © 1996-2020 Information Builders