aggregation in footer not working on first load

[Florian]

Hey together.

I work with advanced databinding using the NeedDataSource event and want to add some aggregations to the footer.

After setting the DataSource I do some changes/formatting to the data in the OnDataBound event.

In this case I iterate through the MasterTableView.AutoGeneratedColumns and want to add Aggregations to all decimal Columns:

if (dataColumn.DataType == typeof(decimal))
{
    ((GridNumericColumn)dataColumn).Aggregate = GridAggregateFunction.Sum;
    ((GridNumericColumn)dataColumn).FooterText = string.Empty;
    ((GridNumericColumn)dataColumn).FooterAggregateFormatString = "{0}";
}

 

My problem is, that this only works after a Postback or Rebind but not on the first load. I press refresh or do some sorting on the table and the sum shows up in the footer.

But Rebinding in this event is not possible, so what can I do to see my aggregations on first load? Is there a better event than OnDataBound?