Field Aggregation

It is often that you need to sum a field column and display the total at the bottom. JSPMaker makes it extremely easy.

For example, to set up the Field Average for the "Quantity" field, select "AVG" for the "Aggregate" column of this field in the Field Setup Page.

To set up the Field Total for the "UnitPrice" field, select "TOTAL" for the "Aggregate" column of the "UnitPrice" field.

In the generated script, the Field Aggregate will be shown in the footer of the "Orderdetails" list page as follow: