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!
--


Reply via email to