UltraWebGrid Infrastructure - Bottom Line
I am currently using UltraWebGrid
the Infragistics control and I am showing the sum of the column values in the footer.
The problem is that since I am using paging, the total displayed in the footer is only calculated by the values of the current page , but I want the sum of all items in the source, not just the current page
Has anyone experienced this problem before?
Here is the code:
myGrid.Columns.FromKey("NoOfSubs").Footer.Total = UltraWebGrid.SummaryInfo.Sum
myGrid.Columns.FromKey("NoOfSubs").Footer.Formula = "SUM([NoOfSubs])"
myGrid
is UltraWebGridControl
source to share
I think your best bet here is unfortunately to run a separate query to get your totals and use it for display. This not only solves the problem of summarizing data at the page level, but also separates you from the constraint on the bottom of the table with just a brief description of the Infragistics table.
source to share