Grid Control Suggestions

[RBSTR]

Hi

I currently use a MSHFlexGrid with a recordset datasource.

It includes a column with a '+' sign that allows the user to drill down to child items under that row - a bit like subtotals in Excel

Something like this

| - | PARENTCODE1 | £100.00 |
| | CHILDCODE1A | £75.00 |
| + | PARENTCODE2 | £250.00 |
| - | PARENTCODE3 | £60.00 |
| | CHILDCODE3A | £55.00 |
| | CHILDCODE3B | £190.00 |

I have coded this through keypresses, setting the 'child' row's height to 0 to hide them when the user clicks '-' sign and then set row hieight back up again when user click '+'.

The user would now like further 'Excel' type functionality - enabling column filter by clicking on column headers to record a value to filter on.

I wonder whether there may be a better control I can use to enable such functionality more easily than MSHFlexGrid? VB6 would be my preference but I may also consider any VB.NET controls (outside the scope of this forum I appreciate), integrating these through the Interop forms toolkit.

Users don't need to be able to edit the cells in the grid just set/refresh the values as required on load.

Any suggestions would be appreciated.

 

[Glasgow]

Better late than never. ComponentOne have a few controls that might help. One example:

http://helpcentral.componentone.com.../default.htm?turl=hierarchicaldatadisplay.htm

but I think the ActiveX version of the True DbGrid control (ok for VB6) may also support hierarchical structures.

Bad news is they cost money!