Focal Point
<TABPAGENO OF <TABLASTPAGE as one item in PDF

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3511093052

October 05, 2007, 06:44 PM
henry_ma@agsea.com
<TABPAGENO OF <TABLASTPAGE as one item in PDF
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
October 06, 2007, 09:37 AM
FrankDutch
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

October 08, 2007, 12:24 PM
henry_ma@agsea.com
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
October 08, 2007, 12:41 PM
susannah
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
October 10, 2007, 09:56 AM
ihf
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
October 10, 2007, 10:22 AM
Francis Mariani
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