Skip to Content
0
Jun 01, 2018 at 10:53 AM

Show page subtotal and previous page subtotal in a subreport

419 Views Last edit Jun 12, 2018 at 02:48 PM 2 rev

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