Focal Point
[SOLVED] Storing Page number in Hold File

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

October 15, 2008, 10:03 AM
Piscian
[SOLVED] Storing Page number in Hold File
Hi,

I want to use subfooting on page number. But when I create a field to store page number and hold it, values of page number do not get stored.
Eg. code

TABLE FILE GGSALES
PRINT
CATEGORY
PRODUCT
COMPUTE PAG/I9 = TABPAGENO;
ON TABLE HOLD AS HLD1
END
TABLE FILE HLD1
PRINT
CATEGORY
PRODUCT
BY
PAG
ON PAG SUBFOOT
"THIS REPORT IS CONFIDENTIAL"
ON TABLE SET ONLINE-FMT PDF
END

Is there any way to store page number in hold file?

This message has been edited. Last edited by: Kerry,


Thanks and Regards,
Piscian

WebFocus 714
Windows Server 2003
Enterprise Edition
HTML,Excel,PDF
October 15, 2008, 10:26 AM
<JG>
Piscian,

You do not need to do that.

All you need is

FOOTING BOTTOM
"THIS REPORT IS CONFIDENTIAL"

and that will put it on the bottom of each page.

(updated because I'm sorry I misspelled your name)

This message has been edited. Last edited by: <JG>,
October 15, 2008, 11:18 AM
Darin Lee
For future reference, I don't think that the internal page number variables are initialized when there is only a HOLD file as there are no "pages" produced. In any case, JG has given you the proper technique to do what you need.


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