EJS TreeGrid Paging example

Paging with grouping, sorting, filtering, export and calculations

This example shows various TreeGrid features with server paging on table with 2,000, 10,000 and 50,000 rows.
This example does not use any custom JavaScript or special server script code, all features are set via XML data definitions and provided by TreeGrid!

In table there are fictive resellers around the world with their results from the first two months in year 2004.
In columns Registered, Since, Calls per and Rabat are data related to partner and can be edited only when rows are grouped by Partner (or by Location and Partner).
In columns Orders, Income and Expenses are results from every partner's month and can be edited in any grouping.
Column Gross profit is calculated (Income - Expenses), Discount is calculated (Gross profit x Rabat) and Profit is calculated (Gross profit - Discount).
In bottom Total results row is summary of the results for whole table, in individual group rows when the grid is grouped is summary for given group.
When are rows grouped by Location and Partner you can drag and drop partners to another location, add new partner to the location or delete the partner. You can also change the whole location by choosing another.

Changes in this example are persistent for 10 minutes and are also cleared when switched to another row count (2000, 10000, 50000).