Page 1 of 1

Categorizing Datagrid form

Posted: Tue Aug 22, 2017 2:26 am
by mrk
Hi All

Just curious (well stumped really). I have a data-set which I can import and display on a datagrid (table)just fine. What I would like to do is sort the data by a specific field so that all items with a specific category show under an expandable row (Using a separate datagrid). I could use a treeview for this, but my other selection list is in a datagrid and would like to keep the styling similar.

Example dataset

EquiID | EquipDesc | EquipCat
id1 | item 1 | Cat 1
id2 | item 2 | Cat 2
id3 | item 3 | Cat 1
id4 | item 4 | Cat 2

Bascially I would want "Cat 1" and "Cat 2" to show on the datagrid with the twistie arrow indicating that there are items below.

Any pointers would be greatly appreciated. I've ready the tutorials and played around with the demo scripts, but i'm just not "seeing" how it may be possible.