andyr
10-10-2006, 10:39 AM
It would be great if you could implement 'group by' where you drag a column header to a pannel above the grid and the grid is redrawn with a row per group and a count - a la MS Outlook. These groups can then be expanded to display the items in the group. Multiple group by nesting would be perfect
:D
Example (ascii 'art'):
| ID | Name | Gender |
| 1 | Fred | Male |
| 2 | Bert | Male |
| 3 | Sally | Female |
If you grouped by Gender:
| ID | Name |
| Male (2) |
| Female (1) |
(N.B. Gender column removed from header )
Expanding Male group:
| ID | Name |
| Male (2) |
| 1 | Fred |
| 2 | Bert |
| Female (1) |
Expanding Female group:
| ID | Name |
| Male (2) |
| 1 | Fred |
| 2 | Bert |
| Female (1) |
| 3 | Sally |
:D
Example (ascii 'art'):
| ID | Name | Gender |
| 1 | Fred | Male |
| 2 | Bert | Male |
| 3 | Sally | Female |
If you grouped by Gender:
| ID | Name |
| Male (2) |
| Female (1) |
(N.B. Gender column removed from header )
Expanding Male group:
| ID | Name |
| Male (2) |
| 1 | Fred |
| 2 | Bert |
| Female (1) |
Expanding Female group:
| ID | Name |
| Male (2) |
| 1 | Fred |
| 2 | Bert |
| Female (1) |
| 3 | Sally |