subtotal of each page in footer

  • Thread starter Thread starter toby
  • Start date Start date
T

toby

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
 
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 said:
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


.
Click to expand...
Click to expand...
 
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 said:
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
Click to expand...
end
of the report. ie.
the report end.

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

Toby


.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top