Categorizing Datagrid form
Posted: Tue Aug 22, 2017 2:26 am
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.
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.