Hi just like the title says. I am adding a row at the end of the sort or filter process (_AfterRowFilterChanged and _AfterSortChange) that will contain a total of certain columns that I want to keep as the last row. Is there a way to do this?
copyoftesttable.Rows.Clear() copyoftesttable.Columns.Clear() copyoftesttable = testtable.Copy copyoftesttable.Rows.Clear()
testtable = copyoftesttable.Copy testtable.AcceptChanges()
If testtable.Rows.Count - 1 > -1 Then cg.Compute(testtable, Me.copyofcolumnarray)
'trying to keep my total row at bottom here so it does not sort dgSearchResults.Rows(dgSearchResults.Rows.Count - 1).Fixed = False End If
I'm not sure what you are asking? Have you tried using a summary like I suggested? You would use the InitializeLayout event of the grid and using the Summaries collection on the band to add a summary. You can set the SummaryDisplayAreas property on the override to make the summaries appear fixed on the bottom of the grid.
By the way I am at the point where it sorts fine and when it filters the row is there. It just is not visible at this point. If I export it the row is there.
Can you point me to a link that does something similar please?
Thank you much for your help.
It seems to me that what you want here is a summary, rather than adding an extra row of data and trying to force it to the bottom. You can add a summary to the band using the Summaries collection on the Band.