Joel,

I've played with a bit and finally decided that it wouldn't be useful from VFP. It only works with ADO type data. So, you basically have to do tons of trial and error in code to figure out how to get it to work properly. I was able to use ADO to pull data from SQL Server and display it in the grid. To get hiarchical, collapsable data in the grid, the only way I could make it work was to use Data Shaping. It was waaaaaaaaay too slow to be useful (even for simplistic queries). I even went as far as creating empty ADO recordsets and filling them manually. That would work fine (and fast) for a single layer of data, but no matter what properties I set in the dataset / datatable / datarow objects, I couldn't get the grid to see that it should display a collapsable section. I think I spent a few days trying to make it work and I probably still have the sample code I wrote at work. If you want (and I still have it), let me know and I'll post it or email it tomorrow when I'm at the office. But, I'm afraid you'll come to the same conclusion I did and that is that it's too much trouble. I'm sure if you played with it long enough you could get it to do what you wanted.

HTH,
Chad

>Has anyone used UltraGrid from Infragistics (http://www.infragistics.com/) with FoxPro?
>
>I want to build a several layer drill down and I think the Ultra Grid should be more flexible than the standard VFP grid.
>
>The current product from Infragistiocs uses a newer version of Ultra Grid, but it is packaged with many controls and intended for Dot Net. FoxPro use as an active X is not supported. I called Infragistics and they were nice but would not provide any support if I am using Foxpro.
>
>I cannot get the grid to display any data, much less a several layer drill down.
>
>In a new project with just one remote view of SQL data everything seems to function correctly. The form data enviornment shows the remote view. I drop and size a new grid on my VFP form. I right click on the grid then go to SSUltraGrid Object then Retrive Structure or just Properties. I get the SSUltraGrid Properties form and then click on Groups & Columns Tab.
>
>The Groups and Columns Tab provides a visual representation of the UltraGrid with abilities to Add/Remove/Show/Hide and arrange various elements of the UltraGrid hierarchy. However, no matter how I do it, the Add Groups Add Level Add Column buttons are always grayed out. The help pages says to just click on them and add a new group or level.
>
>It seems there is not a way to attach data (in the case an ODBC remote view of SQL 2000 Table) to attach to the Ultragrid.
>
>I guess my question really is:
>
>
>
>Can UltraGrid work with FoxPro as an Active X control?