This is a migrated thread and some comments may be shown as answers.

Group total on not bind calculated column

1 Answer 95 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Felice asked on 14 Jun 2014, 05:22 AM

I have a grid with a calculated column which is not bind to the db and I would like to calculate the group total based on such column sum (unique name: column).

<MasterTableView CommandItemDisplay="Top" DataKeyNames="Id" DataSourceID="SqlDataSource1">

<GroupByExpressions>

<telerik:GridGroupByExpression>

<GroupByFields>

<telerik:GridGroupByField FieldName="Stgroup" />

</GroupByFields>

<SelectFields>

<telerik:GridGroupByField FieldName="Stgroup" />

</SelectFields>

</telerik:GridGroupByExpression>

</GroupByExpressions>

<Columns>

<telerik:GridEditCommandColumn ButtonType="ImageButton">

<HeaderStyle Width="30px" />

</telerik:GridEditCommandColumn>

<telerik:GridBoundColumn DataField="Id" DataType="System.Int32" FilterControlAltText="Filter Id column" HeaderText="Id" SortExpression="Id" UniqueName="Id" ReadOnly="True">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

<HeaderStyle Width="45px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Code" DataType="System.Double" FilterControlAltText="Filter Code column" HeaderText="Code" SortExpression="Code" UniqueName="Code">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

<HeaderStyle Width="65px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Designation" FilterControlAltText="Filter Designation column" HeaderText="Designation" SortExpression="Designation" UniqueName="Designation">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

<HeaderStyle Width="150px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Description" FilterControlAltText="Filter Description column" HeaderText="Description" SortExpression="Description" UniqueName="Description" ReadOnly="True">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

<HeaderStyle Width="150px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Bkgroup" FilterControlAltText="Filter Bkgroup column" HeaderText="Bkgroup" SortExpression="Bkgroup" UniqueName="Bkgroup" DataType="System.Double">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

<HeaderStyle Width="55px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Stgroup" FilterControlAltText="Filter Stgroup column" HeaderText="Stgroup" SortExpression="Stgroup" UniqueName="Stgroup" DataType="System.Double">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

<HeaderStyle Width="55px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Type" FilterControlAltText="Filter Type column" HeaderText="Type" SortExpression="Type" UniqueName="Type">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Standard" FilterControlAltText="Filter Standard column" HeaderText="Standard" SortExpression="Standard" UniqueName="Standard">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Quantity" FilterControlAltText="Filter Quantity column" HeaderText="Quantity" SortExpression="Quantity" UniqueName="Quantity" DataType="System.Double">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

<HeaderStyle Width="60px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Unit" FilterControlAltText="Filter Unit column" HeaderText="Unit" SortExpression="Unit" UniqueName="Unit" ReadOnly="True">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

<HeaderStyle Width="40px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Cost" DataType="System.Double" FilterControlAltText="Filter Cost column" HeaderText="Cost BYR" SortExpression="Cost" UniqueName="Cost" DataFormatString="{0:N5}" ReadOnly="True">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

<HeaderStyle HorizontalAlign="Center" Width="65px" />

</telerik:GridBoundColumn>

<telerik:GridCalculatedColumn DataFields="Quantity,Cost" DataFormatString="{0:N5}" Expression="{0}*{1}" FilterControlAltText="Filter column column" HeaderText="Tot. Cost BYR" UniqueName="column">

<HeaderStyle HorizontalAlign="Center" />

</telerik:GridCalculatedColumn>

<telerik:GridBoundColumn DataField="Note" FilterControlAltText="Filter Note column" HeaderText="Note BOM" SortExpression="Note" UniqueName="Note">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Note1" FilterControlAltText="Filter Note1 column" HeaderText="Note Comp." SortExpression="Note1" UniqueName="Note1" ReadOnly="True">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

</telerik:GridBoundColumn>

<telerik:GridButtonColumn ButtonType="ImageButton" Text="Delete" CommandName="Delete" FilterControlAltText="Filter column1 column" ConfirmDialogType="RadWindow" ConfirmText="Do you really want to delete this project and all its content?" UniqueName="column1">

<HeaderStyle Width="30px" />

</telerik:GridButtonColumn>

</Columns>

All example I have found are summing bind columns, how can I achieve to get the total of groups on a not bind calculated column?

1 Answer, 1 is accepted

answered on 19 Jun 2014, 07:01 AM

RadGridGroupHeaderAggregatesModified.zip

Hi Felice,

I am sending a sample RadGrid web site to demonstrate a similar functionality. Please run the attached application and let me know if it helps you.

You can also check this sample:
http://www.telerik.com/help/aspnet-ajax/grid-perform-calculations-in-group-header.html

Regards,
Eyup
Telerik

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.