Ahhhh, that's it. The GetAllFilteredInNonGroupByRows is what I needed.

Awesome!! Thanks Mike!!

Hi,

If the ParentRows collection is returning a list of UltraGridGroupByRows, then it means that the parent rows are grouped.

Let's say, for example, that you have a grid with some rows in it. Now you group by a column. The root-level rows in the grid are no longer data rows - they are GroupByRows. The children of those rows are the actual data rows.

If you group by another colmun, then you will create a 3-level hierarchy. The first two levels are GroupByRows and the 3rd level will be the data rows.

So if the ParentRows are GroupByRows, what you would need to do is loop through that collection and get the ChildRows collection from each row. These ChildRows might be data rows or they might be more GroupByRows. If they are GroupByRows, then you need to walk down another level. You will probably need to write a routine to walk down recursively to find all of the actual data rows involved in the summary.

Or, you might be able to get what you want using methods on the Rows collection like GetAllFilteredInNonGroupRows or GetRowsEnumerator.

Hi Mike
Thanks for the reply, and sorry about the delay.

I should have mentioned I tried what you mentioned originally, and it worked when I did 1 level of grouping. (I would access the ParentRows, and go through each Cell to retrieve the individual values.)
But if I add another level of grouping (group by 2 or more columns), then access the ParentRows in SummaryValueChanged, ParentRows are of type UltraGridGroupByRow, and the Cells collection is null. I can't figure out what property I then need to access to get hold of the right Row collection or Cell collection to retrieve the individual cell values.

Any ideas?
Thanks

Mike