[Solved] aggregate functions updating

[david ocasio]

a simple question

do the aggregate functions recalculate if there is a change to the column it is adding up

in other words
if i edit a columns value will it recaclulate

thanks
dco

[Stefan Dobrev]

Hi david,

Currently the grid will not recalculate the aggregate results when a value is changed. We plan to fix this in our next service pack release.

Meanwhile a simple one line workaround can be implemented. You can use the RowEditEnded event with combination of CalculateAggregates() method:

this.gridView.RowEditEnded += (s, args) => this.gridView.CalculateAggregates();

Best wishes,
Stefan Dobrev
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Greg Phaling]

Hi Stefan,

Unfortunately this workaround does not appear to work.  I debugged the CalculateAggregates call and it seems that the aggregates are being recalculated correctly, but the subsequent call to RebindAggregateResultsList does nothing.  Perhaps because the code is commented out:

        private void RebindAggregateResultsList()
        {
            if (!ShowColumnFooters) return;

            //if (this.ItemsControl == null) return;

            //this.ItemsControl.ApplyTemplate();

            //GridViewFooterRow row = this.FooterRow;
            //if (row != null)
            //{
            //    row.ApplyTemplate();
            //    row.Cells.ToList().ForEach(c => c.ApplyTemplate());
            //    row.ChildrenOfType<AggregateResultsList>().ToList().ForEach(l => l.Bind());
            //}
        }

Uncommenting the code does not help as ItemsControl is undefined.  Please advise.

Greg

[Stefan Dobrev]

Hi Greg,

This is already have been fixed and will be available in the next internal release that we are going to publish.

Best wishes,
Stefan Dobrev
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.