At 02:36 PM 10/1/2013, Karen Tellef wrote:
Dennis: I've never tried that before, but looking in my notes
document, I found
the following code that I saved. Could this help you?
If you need to manipulate page numbers,:
1. Main Menu | Report | Actions | Before Generate ...
SET VAR vCurrentPageNumber INTEGER = 0 ; RETURN
2. Enable Cache Pages option
Main Menu | Report | Cache Pages (default is set to OFF)
3. Right-click on Page Header Band | After Generate Custom EEP ...
SET VAR vCurrentPageNumber = (.vCurrentPageNumber + 1)
You saved the code, but forgot to reference the original author.
Here's the original post ...
------------------------------------------------------------------------------
Posted on RBASE-L List:
------------------------------------------------------------------------------
Fri, 24 Feb 2012 18:36:01 -0500 Subj: Re: Capturing page numbers
Thu, 28 Jun 2012 15:28:27 -0400 Subj: Re: System Variable Name for Page Number
------------------------------------------------------------------------------
Here is a very simple and eloquent approach to achieve such goal.
While in Report Designer:
01. Define a global variable, such as vCurrentPageNumber, as
On "Before Generate ..." Report Action
Main Menu | Report | Actions | Before Generate ...
CLEAR VARIABLE vCurrentPageNumber
SET VAR vCurrentPageNumber INTEGER = 0
RETURN
02. Enable Cache Pages option
Main Menu | Report | Cache Pages
The default is set to OFF
03. Now capture the current page number using the following EEP as
After Generate Custom EEP ... for Page Header Band
Right-click on Page Header Band | After Generate Custom EEP ...
SET VAR vCurrentPageNumber = (.vCurrentPageNumber + 1)
RETURN
This approach will provide you with a global variable which you
can capture to achieve your specific objective.
And that's all there is to it!
Very Best R:egards,
Razzak.
------------------------------------------------------------------------------
www.rbase.com
www.facebook.com/rbase
--
30+ years of continuous innovation!
15 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--