subtotal of each page in footer

hi
i 've a report which listed the items from the source database directly.
i've made the sumation of all the items price at the end of the report. ie.
the report end.

but however, if i want to calculate and show the subtotal of the items price
on each page, that how to do it?!!
thanks in advance.

Toby

The only way I know is a true current subtotal.
You could do this by creating a second textbox in you
detail with asource of the item you wish to subtotal, set
its visibility to no and sum to overall. Let's say the
textbox name is "Text21"
Now at the page footer create an unbound textbox and set
its source to =[Text21].
This textbox will now show the current subtotal at the
bottom of each page.
Hoep this gets you started.
Fons
-----Original Message-----
hi
i 've a report which listed the items from the source
database directly.
i've made the sumation of all the items price at the end
of the report. ie.
the report end.

but however, if i want to calculate and show the subtotal
of the items price
on each page, that how to do it?!!
thanks in advance.

Toby


.

Dear Fons Ponsioen
but this one comes up a problem is that i can online calculate for one page
only. right?!?
if i hv 4 pages of data, and each page i need the subtotal on the footer,
then that method cant meet wht i need !
am i right?

Toby

"Fons Ponsioen" ???
???...
The only way I know is a true current subtotal.
You could do this by creating a second textbox in you
detail with asource of the item you wish to subtotal, set
its visibility to no and sum to overall. Let's say the
textbox name is "Text21"
Now at the page footer create an unbound textbox and set
its source to =[Text21].
This textbox will now show the current subtotal at the
bottom of each page.
Hoep this gets you started.
Fons
-----Original Message-----
hi
i 've a report which listed the items from the source
database directly.
i've made the sumation of all the items price at the end
of the report. ie.
the report end.

but however, if i want to calculate and show the subtotal
of the items price
on each page, that how to do it?!!
thanks in advance.

Toby


.

Hi Toby.
Yes, what I gave you is a current sub-total.
What that means is it summarizes the subtotal on page one,
than the subtotal on page 2 is the sum of page 1 and page
2 and so on.
Maybe a repost may come up with some other solution if you
need that.
Fons
-----Original Message-----
Dear Fons Ponsioen
but this one comes up a problem is that i can online
calculate for one page
only. right?!?
if i hv 4 pages of data, and each page i need the
subtotal on the footer,
then that method cant meet wht i need !
am i right?

Toby

"Fons Ponsioen" ???
???...
The only way I know is a true current subtotal.
You could do this by creating a second textbox in you
detail with asource of the item you wish to subtotal,
set
its visibility to no and sum to overall. Let's say the
textbox name is "Text21"
Now at the page footer create an unbound textbox and set
its source to =[Text21].
This textbox will now show the current subtotal at the
bottom of each page.
Hoep this gets you started.
Fons
-----Original Message-----
hi
i 've a report which listed the items from the source
database directly.
i've made the sumation of all the items price at the
end
of the report. ie.
the report end.

but however, if i want to calculate and show the
subtotal
of the items price
on each page, that how to do it?!!
thanks in advance.

Toby


.



.