Adding page totals to reports

Listings can often span multiple pages making it easy to lose track of the totals. NAV allows you to easily add a textbox to the bottom or top of a page to show these subtotals to the user.

How to do it...

1. Create a new report using the Report Generation Wizard on table 21, Cust. Ledger Entry.

2. On the second wizard window, add the Customer No., Posting Date, and Amount fields.

3. On the third wizard window, set the Sorting Order to Customer No., Posting Date, Currency Code.

4. Click Finish.

5. View the sections for the report.

6. Add a second Header section.

7. Move the column labels to the Header section.

8. Add a TransHeader section.

9. Add a TransFooter section.

10. Add a textbox to both sections.

11. Set the following property on each textbox control:

    Property	Value
    SourceExpr	Amount

12. Add a textbox to the TransHeader section.

13. Set the following property on the textbox control:

    Property	Value
    SourceExpr	'Transferred from previous page'

14. Add a textbox to the TransFooter section.

15. Set the following...