I have some specific request from my client. So I have simple orders browse (usual SQL table, standard BrowseBox) with several columns including “route” and “customer” columns.
And the request is that orders which have the same route and customer should be grouped together in one row + have some total columns.
However, the user can have the functionality to expand such line in order to see in detail all the orders in a group.
What is the best and easiest way to implement this?