[Solved] Suggestion for grouping data, handling sorting, filtering, etc

[Jerry Kurata]

Hi,

Our users want to group data at specific levels.  This will result in values that were displayed in separate rows being displayed in the same cell.  For example for a sales force the original data could be:

District         Office         SalesPersonID  Customer X Sales         Customer Y Sales
D1                  O1              12334                123.45                            445.45
D1                  O1              22222                456.45                            515.23
D1                  O1              33333                342.34                            678.21
D1                  O2              99923                   ----                               345.67
D1                  O2              65465                 456.34                           512.34

When the data is grouped by Office the data would be displayed as:

District         Office      Customer X Sales         Customer Y Sales
D1                  O1         123.45,342.24,            445.45, 515.23,
                                     456.45                         678.21
D1                  O2         456.34                          345.67, 512.34

Also, the sorting and filtering for the Customer Sales columns would be based on the highest value in their lists.

One way to accomplish this would be to generate a new underlying datasource  such as a table that combines the data and add a hidden filter/sort key column such as:
District         Office      Customer X Sales         Customer X Key        Customer Y Sales          Customer Y Key
D1                  O1         123.45,342.24,            456.45                       445.45, 515.23,             678.21
                                     456.45                                                          678.21
D1                  O2         456.34                          456.34                      345.67, 512.34               512.34

My question is does the grid provide an easier way of accomplishing these tasks?

[Stefan Dobrev]

Hi Jerry,

RadGridView will not be able to help you in this case. However you can use QueryableCollectionView class in order to perform the grouping and project the results into your own class that the grid will be bound to. You can check out MicroModels framework which might help you as well.

Hope this helps,
Stefan Dobrev
the Telerik team