Mike Lewis
Programmer
Can anyone recommend a third-party control that will do the following. It could be a native VFP control, or an ActiveX component. It doesn't have to be free.
Basically, I need a "drill-down grid". I need it to show 6 - 8 columns, with the ability to interactively expand a given row to show another level of rows below it. Those subsidiary rows might have the same columns as the top level rows, or they might have more colums.
If you can imagine a treeview inside a grid, that's roughly what I'm looking for.
I'd also like as many of the following features as possible:
- Click on a column header to sort the column.
- Allow drag-and-drop from the control.
- Conditional highlighting (like VFP's DynamicXXX properties)
- Interactively moving and resizing columns.
So far, I've looked at the following possibilities:
- Microsoft's Treeview. But this doesn't support multiple column per row.
- Microsoft's MSFLXGRD and MSHFLXGRD. I don't know these well enough to know if they would meet my needs. It seems like the MSHFLXGRD should, as it supports hierarchical data, but it looks like I would have to set up an ADO recordset to make that work, which seems like an unnecessary complication.
- The DBI Component Toolbox. This has a tree control which is perfect for my needs. The problem is the cost. I already own a copy, but my client would need a licence for each of their developers, and the total cost will be high.
If anyone could point me in the right direction, it would be helpful. Thanks.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Visual FoxPro tips, advice, training, consultancy
Custom software for your business
Basically, I need a "drill-down grid". I need it to show 6 - 8 columns, with the ability to interactively expand a given row to show another level of rows below it. Those subsidiary rows might have the same columns as the top level rows, or they might have more colums.
If you can imagine a treeview inside a grid, that's roughly what I'm looking for.
I'd also like as many of the following features as possible:
- Click on a column header to sort the column.
- Allow drag-and-drop from the control.
- Conditional highlighting (like VFP's DynamicXXX properties)
- Interactively moving and resizing columns.
So far, I've looked at the following possibilities:
- Microsoft's Treeview. But this doesn't support multiple column per row.
- Microsoft's MSFLXGRD and MSHFLXGRD. I don't know these well enough to know if they would meet my needs. It seems like the MSHFLXGRD should, as it supports hierarchical data, but it looks like I would have to set up an ADO recordset to make that work, which seems like an unnecessary complication.
- The DBI Component Toolbox. This has a tree control which is perfect for my needs. The problem is the cost. I already own a copy, but my client would need a licence for each of their developers, and the total cost will be high.
If anyone could point me in the right direction, it would be helpful. Thanks.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Visual FoxPro tips, advice, training, consultancy
Custom software for your business
)))))
