Hi everybody

I am faced with a tricky problem for which I need a solution urgently


I have a report whose sections and contents are detailed below

Page header-a
Page header-b
Group header-1

The group header-1 contains a subreport whose sections are detailed below

    report header-a which is suppressed
    report header-b which is suppressed
    group-header-1 which contains some headings

    Details contains the fields to be displayed.Also contains a
    formula that stores the sum of a field.I am using a shared
    variable for passing values between the mainreport and the
    subreport

    Group footer-1 is suppressed
    report footer a is supressed
    report footer b is suppressed


Main report sections continued


Details section suppressed
group footer-1 supressed
report footer enabled contains nothing
page footer-a
page footer-b contains a formula to display the value of a shared variable 'qtytot' that is totalled in the subreport

page footer-c contains a formula to reset the value of the shared variable

Now onto my problem

For certain items the subreport has more than one page
For example say item d/1/a has 3 pages
In page-1 and page-2 the page total is shown as 0. In the last page
that is page-3 the total is displayed correctly

My question is how to get the page totals to be displayed correctly on each page

Thanks in advance

Mathew

say lets tell we need amount totals in each page. then we go ahead and do this.

To display amount totals in each page:
You need to use three formulae for this

formula1 @Reset
numbervar n;
whileprintingrecords;
n:=0

FORMULA2 @DETAILS
numbervar n;
whileprintingrecords;
n:=n+ToNumber({@Amount});

formula3 @Display
numbervar n;
whileprintingrecords;
n;

Place Formula1 at Report Header and suppress
Place Formula2 at Details Section and suppress
Place Formula3 at Report Footer and dont suppress


rupi