I have this Radgrid where I use a calculated column "column" to get the total value per row. I use a calculated column because the two items "Quantity" and "Cost" come from different db tables.
I am experiencing problem in getting the total value of each Group aggregated as sum in the group header. I have checked the documentation but still I am unable to get it. I would really appreciate if someone here can support me with an example based on the above grid. Thanks a lot,
Felice
<
MasterTableView
CommandItemDisplay
=
"Top"
DataKeyNames
=
"Id"
DataSourceID
=
"SqlDataSource1"
PageSize
=
"3000"
GroupsDefaultExpanded
=
"false"
>
<
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
>
<
EditFormSettings
>
<
FormStyle
BackColor
=
"Yellow"
/>
<
EditColumn
UniqueName
=
"EditCommandColumn1"
FilterControlAltText
=
"Filter EditCommandColumn1 column"
></
EditColumn
>
</
EditFormSettings
>
<
PagerStyle
AlwaysVisible
=
"True"
Mode
=
"NextPrevNumericAndAdvanced"
PageButtonCount
=
"50"
/>
</
MasterTableView
>
Felice