I'm using the GetSummary Function on a datagrid and the summary part works great, the problem is that i'm only able to see the first row of the datagrid.  None of the other rows appears.

Here is the code i'm using to get the totals i need:

    If Column.FieldName = "A2_TOTALPAYMENTS" Or Column.FieldName = "SO_TOTAL" Or Column.FieldName = "TOTAL_TAX" Or Column.FieldName = "SUB_TOTAL" Then
        Dim rs, amnt
        amnt = 0
        Set rs = Sender.RecordSet
        If rs.RecordCount > 0 Then
            rs.MoveFirst
            While Not rs.EOF
                If IsNull(rs.Fields("UN_CANCELED_BYID").Value) Then
                    If Not IsNull(rs.Fields(Column.FieldName).Value) Then
                        amnt = amnt + CDbl(rs.Fields(Column.FieldName).Value)
                    End If
                End If
                rs.MoveNext
            Wend
        End If
        Set rs = Nothing
        Value = amnt
    End If

If i take out the looping then all the rows show up, but the only way to get what i need without doing another call to the database is to loop through the recordset.

Any thoughts would be appreciated.

When do you set the grid.recordset = rs?

what happens if you don't set the rs to nothing?

What happens if you do a rs.movefirst as the last line of code before the end if?

I don't set the grid.recordset in this method. When i have tried that i get an error saying that the recordset is not open.

If I don't set the rs to nothing then i get memory leaks.

Setting the rs.movefirst after doing the looping doesn't do anyting.

Solunds like SLX doesn't like the recordset\ and or it's not a valid record set.

Do you have a valid grid object (Columns? SQL?)

I always create a recordset and then

Set grid.recordset = myRS

Always.

It is a valid recordset.

I've stepped thourhg the code and there are records in the record set. 

I've done it both with grids bound using the desinger and with grids i've created in code and i get the same result.

Obviously we are unable to figure out what a valid recordset with a summary row in it looks like that is SLX Grid compatible.....

This is one area I've never worked on so I am of no further help......have done extensive cusomizations with the Header grouping functionality......not the Summary footer stuff....