Language:


Adding and Editing Objects in Form Templates - Page Sums

This page describes adding page sums to a Form Template.

---

A page sum will print a running total for a particular Matrix or row field on each page.

To add a page sum to a Form Template, click the [Page Sum] button at the top of the Form Template window:

Then use the mouse or trackpad to mark the position of the page sum. When you release the mouse button, a dialogue box will open:

Fieldname
Paste Special    Fields for the Form Type
Use 'Paste Special' to choose the field for which a running total is to be printed. This must be a numeric matrix field (for example, the "Row Sum" field in Quotations, Orders and Invoices). You should add the field to the Form Template before adding the page sum, otherwise the page sum won't be printed.

Field Argument
If the field is one where you can specify a Field Argument (e.g. to specify the number of decimal places that will be printed), you can specify the same Field Argument for that field's page sum. If you do specify a Field Argument for a page sum, it will also be used in the field itself, overruling any Field Argument that you may have specified there.

Left, Top, Right, Bottom
Use these fields to specify the size and position of the page sum on the page. When you add a new row sum to a Form Template, the measurements of the box that you have just drawn will appear here.

Style
Paste Special    Styles setting, System module
Use this field to assign a font and font style to the page sum. If you do not enter a Style here, the first record in the Styles setting will be used.

Line Height
There will usually be no need to specify a Line Height in page sums.

Format
The Format should usually be 0 in page sums (if you set the Format to 1, the figures that make up the page sum will be printed individually.

Exclude from page
Please refer to the Single- and Multi-Page Forms page for details about these options. Usually, you would exclude a page sum from Single pages and, depending on the Sum Of options below, from Last pages.

Justification
Use these options to specify where the text will be printed inside the field.

Clipping
These options control how the text in a page sum will be printed if the field is not wide enough to contain it. If Clipping is On, the text will be truncated (i.e. only the text that fits inside the field will be printed). If Clipping is Off, the text will not be truncated so part of it will be printed outside the field.

An alternative to clipping is to use the Word Wrap options below.

Word Wrap
Use these options to control how the contents of a field will be printed if the field is not wide enough.
Off
The contents will be truncated to fit the width of the field.

On
The contents will be printed on several lines, with the width of the field being preserved. You must make the field deep enough to accommodate the possibility that more than one line will be printed. You should only use Word Wrap in Header fields.

Sum Of
Use these options to specify how the running total will be calculated.
Current Page
The running total will be the total for the current page.

Previous Page
The running total will be the total for the previous page.

All Previous Pages
The running total will be the total for all previous pages.

Current and Previous
The running total will be the total for the current and all previous pages.
Click [OK] to save. The row sum will be added to the Form Template. You can move it by dragging and dropping.

Please refer to the following pages for details about the different types of object that you can add to Form Templates:
---

The Form Template register in Standard ERP:

Go back to: