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

Group total on not bind calculated column

1 Answer 79 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Felice
Top achievements
Rank 1
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

Sort by
0
Eyup
Telerik team
answered on 19 Jun 2014, 07:01 AM
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.

 
Tags
Grid
Asked by
Felice
Top achievements
Rank 1
Answers by
Eyup
Telerik team
Share this question
or