I am trying to print a packing slip using the report designer. My packing slip details are the items shipped. Each item has an associated weight.

I already created a "Variable" named "TotalWeight_OnThisPage" to sum all the weights of items printed on the current page.

If the packing slip must print on multiple pages I also need along with the "TotalWeight_OnThisPage" another calculation which represents the total weight of the previous page.

for example:

if my packng slip runs for 3 pages and the total weight of all items shipped is 8000 lbs, the following must be present at the footer of each page.

Page 1
=======

Pounds on this sheet: 2000 ==>(TotalWeight_OnThisPage"
Pounds of previous sheet: 0
Total Pounds: 8000

Page 2
=======

Pounds on this sheet: 5000 ==>(TotalWeight_OnThisPage"
Pounds of previous sheet: 2000
Total Pounds: 8000

Page 3 (final)
=======

Pounds on this sheet: 1000 ==>(TotalWeight_OnThisPage"
Pounds of previous sheet: 5000
Total Pounds: 8000

Can this be accomplished within the report designer!

Thanks in advance!