I have a subreport which displays items and prices.
if the report splits into more pages, I should display the subtotal of prices for every page, and show it at the beginning of the next page.
previous page subtotal should not appears at first page, and the subtotal of last page should be replaced by the global total
for example
(Details) (Page 1) item 1 - price 1 ... subtotal: s1 (Page 2) previous subtotal: s1 item n - price n ... subtotal: s2 ... (Last page) previous subtotal: sn item - price global price total: xx
how can I get it?
I tried to create a detail section for previous page subtotal and forced to suppress when pagenumber = 1, but in the next pages the section is repeated at every item.
I also tried to place subtotal in a page header, but it doesnt exist in a subreport