Hello, i'm new to Nav and i have to modify a report for a customer; The original report is structured with header, body and footer they asked me to print at the begin of the body, for every page, the sum of the field of the previous page, and at the end of the body the sum of the field of the current page.
So the situation must be like this:
page 1
Header
-------------------
Body
blank ( cause this is the first page)
record 1
record 2
record 3
sum of (record1.field, record2.field, record3.field)
-------------------------------------------------
footer
_______________________________________________________
page 2
Header
-------------------
sum of (record1.field, record2.field, record3.field)
blank ( cause this is the first page)
record 4
record 5
record 6
sum of (record4.field, record5.field, record6.field)
-------------------------------------------------
footer
.... etc etc..
How can i do this? even without using a fixed number of lines for page, but i need a solution and i can't find it...
*This post is locked for comments