Footer not reloading after Expanding a column

[Shane]

Greetings,

I am populating my footer using the following ItemDataBound Event:

protected void rGridReporting_ItemDataBound(object sender, GridItemEventArgs e)
        {
            var subList = (List<VendorSubTotal>)Session["SubList"];

            if (!(e.Item is GridFooterItem) || subList.Count == 0) return;

            var footer = (GridFooterItem)e.Item;

            var t855 = subList.Sum(v => v.Total855);
            var t856 = subList.Sum(v => v.Total856);
            var t810 = subList.Sum(v => v.Total810);
            var p855 = t855 / subList.Count;
            var p856 = t856 / subList.Count;
            var p810 = t810 / subList.Count;

            footer["vName"].Controls.Add(new LiteralControl("<div style='color: Black; font-weight: bold;'>Report Grand Totals:</div> "));
            footer["t855"].Controls.Add(new LiteralControl("<div style='color: Black; font-weight: bold;'>" + t855 + "</div> "));
            footer["p855"].Controls.Add(new LiteralControl("<div style='color: Black; font-weight: bold;'>" + p855 + "</div> "));
            footer["t856"].Controls.Add(new LiteralControl("<div style='color: Black; font-weight: bold;'>" + t856 + "</div> "));
            footer["p856"].Controls.Add(new LiteralControl("<div style='color: Black; font-weight: bold;'>" + p856 + "</div> "));
            footer["t810"].Controls.Add(new LiteralControl("<div style='color: Black; font-weight: bold;'>" + t810 + "</div> "));
            footer["p810"].Controls.Add(new LiteralControl("<div style='color: Black; font-weight: bold;'>" + p810 + "</div> "));
        }

The problem I am having occurs when I expand or collapse a column the event doesn't fire and my footer is not reloaded. When I re-order the fields of the grid or using paging the footer is reloaded just fine. Any suggestions would be most helpful.

Thanks!

[Mira]

Hello Shane,

The described behavior is expected because the ItemDataBound event is fired only when the grid binds to data.
To implement the desired functionality, I suggest that you keep a reference to the GridFooterItem and update its content when necessary.

Please, give this approach a try and let me know whether it helps.

Best wishes,
Mira
the Telerik team

[Shane]

Thank you for your reply. I ended up using aggregates to accomplish what I was trying to do. I was able to do the the formatting and calculations in the HTML using various Column properties. For the more complex calculations I used a Custom Aggregate and used the OnCustomAggregate Event.

<telerik:GridBoundColumn HeaderText="% of 855's Rec" Aggregate="Custom" AllowSorting="true" DataFormatString="{0:P0}" FooterAggregateFormatString="{0:P0}"  DataField="Percent855" SortExpression="Percent855" UniqueName="p855"><ItemStyle HorizontalAlign="right" /><FooterStyle HorizontalAlign="right" Font-Bold="true" /></telerik:GridBoundColumn>

protected void rGridReporting_CustomAggregate(object sender, GridCustomAggregateEventArgs e)
        {
            var poList = getPurchaseOrders(null);
            var totalPos = poList.Count;
            var total855 = poList.Count(purchaseOrder => purchaseOrder.Rec855Date != null);
            var totalPos856 = poList.Count(purchaseOrder => purchaseOrder.FirstReceipt != null);
            var total856 = poList.Count(purchaseOrder => purchaseOrder.FirstReceipt != null && purchaseOrder.Rec856Date != null);
            var total810 = poList.Count(purchaseOrder => purchaseOrder.Rec810Date != null);

            switch (e.Column.UniqueName)
            {
                case "p855":
                    var percent855 = (decimal)total855 / totalPos;
                    e.Result = percent855;
                    break;
                case "p856":
                    var percent856 = (decimal)total856 / totalPos856;
                    e.Result = percent856;
                    break;
                case "p810":
                    var percent810 = (decimal)total810 / totalPos;
                    e.Result = percent810;
                    break;
            }
        }

This would return the correct value based on the unique name of the column. Cheers to anyone this helps!

Thanks Again Telerik Admin!