General information
Category:
Reports & Report designer
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!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only