Aggregate on autogenerated columns

[Darren]

Hi, is it possible to assign an aggregate to an autogenerated column and if so how can I do it. I haven't found an example and I don't see how to do it in the ColumnCreating or ColumnCreated events. Hopefully these can also be exported to excel.

Thanks.

[Princy]

Hello Darren,

You can try out the following code to set the aggregate function for columns:
c#:

  protected void RadGrid1_ColumnCreated(object sender, GridColumnCreatedEventArgs e)
    {
        if (e.Column is GridBoundColumn)
        {
            (e.Column as GridBoundColumn).Aggregate = GridAggregateFunction.Count;
        }
    }
  // use the same logic for other column types that support aggregates

NB: Also set the ShowFooter property of the grid to true.

Thanks
Princy.

[Darren]

Hi, thanks for the reply. When i try this and enable the footer I am getting an error. if i don't display the footer i don't get the error.

Cannot find column [hs_grad_year].

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.EvaluateException: Cannot find column [hs_grad_year].

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[EvaluateException: Cannot find column [hs_grad_year].] System.Data.AggregateNode.Bind(DataTable table, List`1 list) +1225430 System.Data.DataExpression.Bind(DataTable table) +59 System.Data.DataExpression..ctor(DataTable table, String expression, Type type) +4820647 System.Data.DataTable.Compute(String expression, String filter) +57 Telerik.Web.UI.GridBoundColumn.ApplyAggregates(TableCell cell, String footerText) +2000 Telerik.Web.UI.GridBoundColumn.cell_DataBinding(Object sender, EventArgs e) +741 System.Web.UI.Control.OnDataBinding(EventArgs e) +99 System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +92 System.Web.UI.Control.DataBind() +15 System.Web.UI.Control.DataBindChildren() +211 System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +102 System.Web.UI.Control.DataBind() +15 Telerik.Web.UI.GridItem.SetupItem(Boolean dataBind, Object dataItem, GridColumn[] columns, ControlCollection rows) +1011 Telerik.Web.UI.GridTableView.CreateFooterItem(Boolean useDataSource, GridColumn[] copiedColumnSet, GridTFoot tfoot) +126 Telerik.Web.UI.GridTableView.CreateControlHierarchy(Boolean useDataSource) +1096 Telerik.Web.UI.GridTableView.CreateChildControls(IEnumerable dataSource, Boolean useDataSource) +786 System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) +57 System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) +114 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +31 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +142 Telerik.Web.UI.GridTableView.PerformSelect() +28 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73 Telerik.Web.UI.GridTableView.DataBind() +368 Telerik.Web.UI.RadGrid.DataBind() +165 Telerik.Web.UI.RadGrid.AutoDataBind(GridRebindReason rebindReason) +3849 Telerik.Web.UI.RadGrid.OnLoad(EventArgs e) +175 System.Web.UI.Control.LoadRecursive() +50 System.Web.UI.Control.LoadRecursive() +141 System.Web.UI.Control.LoadRecursive() +141 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

[Shinu]

Hi Darren,

Are you using a hierarchical RadGrid? Is your grid having a column named 'hs_grad_year' ? if so is it in the detail table or master table?

Shinu

[Darren]

It is a regular 1 level grid and the column exists, autogenerated. Thanks.

[Princy]

Hi,

Could you please post your aspx here as I am not able to replicate the issue. I have tried the code snippet by Shinu  abnd it is working fine on my end,

Thanks,
Princy

[Fabian Raul Jofre]

I have excacttly the same mistake.
Do you have a solution for this?

This happend if your columns are generated dinamycally.

Example:
    Fisrt Time Datasource:
            Column1 | Colum2 | Column3

First time everything is ok.

    Second Time
            Column1 | Column3 | Column4

Here is the problem. The "Column 4"

The first time Column2 didn´t exist.



 Exepcion:
   - Origen: System.Data
   - Mensaje: No se puede encontrar la columna [RET. FED. IMP].
   - StackTrace:    en System.Data.AggregateNode.Bind(DataTable table, List`1 list)
   en System.Data.DataExpression.Bind(DataTable table)
   en System.Data.DataExpression..ctor(DataTable table, String expression, Type type)
   en System.Data.DataTable.Compute(String expression, String filter)
   en Telerik.Web.UI.GridBoundColumn.ApplyAggregates(TableCell cell, String footerText)
   en Telerik.Web.UI.GridBoundColumn.cell_DataBinding(Object sender, EventArgs e)
   en System.Web.UI.Control.OnDataBinding(EventArgs e)
   en System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   en System.Web.UI.Control.DataBind()
   en System.Web.UI.Control.DataBindChildren()
   en System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
   en System.Web.UI.Control.DataBind()
   en Telerik.Web.UI.GridItem.SetupItem(Boolean dataBind, Object dataItem, GridColumn[] columns, ControlCollection rows)
   en Telerik.Web.UI.GridTableView.CreateFooterItem(Boolean useDataSource, GridColumn[] copiedColumnSet, GridTFoot tfoot)
   en Telerik.Web.UI.GridTableView.CreateControlHierarchy(Boolean useDataSource)
   en Telerik.Web.UI.GridTableView.CreateChildControls(IEnumerable dataSource, Boolean useDataSource)
   en System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
   en System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
   en System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
   en System.Web.UI.WebControls.DataBoundControl.PerformSelect()
   en Telerik.Web.UI.GridTableView.PerformSelect()
   en System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
   en Telerik.Web.UI.GridTableView.DataBind()
   en Telerik.Web.UI.RadGrid.DataBind()
   en Reporte_Cierre_Puntos_Mensual.ArmarTabla() en c:\Documents and Settings\arielr.INTRANET\mis documentos\visual studio 2008\websites\virtualcash\Reporte_Cierre_Puntos_Mensual.aspx.cs:línea 165

[Sebastian]

Hello Fabian,

From the stack trace of the error you provided tt seems that in your case the aggregates for your columns cannot be generated at a certain stage of the grid lifecycle. Can you please verify that the columns are generated programmatically in par with the concepts explained in this documentation topic? This will ensure that their lifecycle and viewstate will remain consistent and the aggregates should be calculated as expected.

Best regards,
Sebastian
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.

[Danyal Rashid]

For anyone else coming across this issue, following info might help

We came across this issue after we upgraded 2009.3.1103.35 to 2011.3.1115.35

Our scenario:
- Custom user control ucGrid that contains our RadGrid along with some other asp.net controls. Entire ucGrid is ajaxified and data is populated using RadGrid.DataBind during an Ajax request.
- RadGrid has 2-3 predefined template columns  such as checkboxes and images (defined in aspx page with MasterTableView AutoGenerateColumns="False"
- All data columns (custom class that inherits from GridBoundColumn) populated during Page Load event (!IsPostback).
- All properties set AFTER adding the column to MasterTableView as recommended. Some columns have aggregate properties set
- Some additonal properties are set using MasterTableView.GetColumn
- etc. etc. etc.

All works fine as expected in 2009.3.1103.35 but not in 2011.3.1115.35
* MasterTableView.GetColumn does not work, MasterTableView.Columns.FindByUniqueName works
* Exception that column is not found in System.Data.AggregateNode.Bind method

Upgrading to Q3 2011 SP1 2011.3.1305.35 fixed both issues. Issue 1 is actually documented in release notes (http://www.telerik.com/products/aspnet-ajax/whats-new/release-history/q3-2011-sp1-version-2011-3-1305.aspx).

It would have been nice to document the aggregate exception issue as well.

Thanks