A summary is a brief account that contains the main points of a certain field. The main purpose of such a simplification is to highlight the major points from genuine (much more extensive) data.
With the use of summary, in an application, user is only given data that he really needs. Then it is up to him if he wants to know how and why data is like it is shown in the summary. Several types of summary can be used: sum, minimum value, maximum value, average value or count. The type of the summary can also be changed in runtime. This is done simply with a right click on the field in grid footer. In pop up menu user can then choose the desired summary type.
In order for the summary to be visible in the control, its property ShowFooter must set to True.
Example (MxSpace)
User requirements specify that a grid must have summary for all values of a specific field.
In the user interface for managing work orders in a grid displaying work orders, fields Planned Qty and Actual Qty must have a information about the sum of all records currently displayed in the grid. To see the implementation of a summary in MxSpace application click Production -> Manage. See that fields Planned Qty. and Actual Qty. have summary displayed.
To create summary on a field
- Open appropriate adapter (WorkOrderAdapter) in Solution Explorer.
- Expand the desired field (PlannedQuantity) in the appropriate data source schema (WorkOrder).
- Click Summary and select Sum in the property SummaryType.
- In property SummaryFormat write "SUM {0:n2}".
- Open appropriate part (WorkOrderManagePart) in Solution Explorer.
- Select GridEdit control (WoGridEdit) and open Properties window.
- Set property ShowFooter to True.
MxPart
ShowFooter
MxAdapter
Read Only
Default Value
Mask