WebGrid provides two distinct ways to display aggregate values. When the GroupTotal feature is enabled, a special Total Row is added after the group header to display the calculated value. For less demanding Aggregate value displays, display the value in the GroupHeader itself, preserving screen space and reducing clutter.
When GroupTotalVisible is enabled, WebGrid will show a group total row on each group and display the aggregate results of each column based on the specified AggregateFunction. This row uses the WebGrid's AutoLayout to synchronize its width with its parent column, keeping the aggregate value aligned for a more readable display. Group Total is also designed to work in conjunction with Client Binding operation by initially preloading the group totals during server-side data fetching process. Learn more
When operating in Client Binding mode, it is previously impossible to display the group totals due to the heavy data processing and aggregate computation in the client side. The new Preload Group Total feature provides an elegant solution to display the aggregate results by preloading the group totals during server-side data retrieval process. Learn more
VirtualLoad™ paging is an advanced data paging mechanism by retrieving only subsets of data initially and loads the next data on demand when required. It now works in concert with grouping feature which enables the group rows to be paged and partially loaded. The result is obvious – richer user experiences, increased application responsiveness and more efficient resources utilization. Learn more
WebGrid offers a complete set of aggregation functions which you can apply to all rows, or groups of rows. When you require calculations beyond the standard aggregation functions such as Count, Sum, Average, Min and Max, this feature allows you to construct your own calculations as needed.
The WebGrid GroupBox serves two purposes – it displays the current grouping hierarchy, and provides a convenient drag-and-drop method of grouping by columns. To add a column, just drag the column header into the group box. Removing a column is just as easy – simply drag it back out of the GroupByBox area. The column header contextual menu handles both these actions as well as the GroupByBox display control.
In addition to the column value, control grouping with one of eight new Interval types, including Text, Alphabetical, Date, Month, and ShortTime.
This innovative feature will reduce your development time as well as create a more reliable aggregate value display. When any value on which an aggregate depends is changed, the aggregate total is automatically recalculated and the display updated, eliminating the need to recalculate on every data edit.