Hi,
I have a Grid and group the by country.
can I format the group footer like "China Total: 10" , "US Total: 20", "UK Total :30", then "Grand Total:60" in the footer?
allow me to include the dataViewRow in the Footer?
Currently, I am using template column like that:
<telerik:GridNumericColumn
UniqueName="AreaSize"
HeaderText="GFA Size"
DataField="area_size"
FooterAggregateFormatString="Total: {0:###,###.00}"
Aggregate="Sum" >
</telerik:GridNumericColumn>
or can I add the DataRowView in the footer by using this?
| protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e) |
| { |
| if (e.Item is GridGroupFooterItem) |
| { |
| GridGroupFooterItem groupFooter = (GridGroupFooterItem)e.Item; |
| groupFooter.Cells[4].Text = "Custom TEXT for agregate count: "; |
| } |
| } |

<telerik1:RadGrid ID="RadGrid1" runat="server" Skin="Web20"
GridLines="None" AllowPaging="True" AllowSorting="True"
Width="97%" AutoGenerateColumns="False"
ShowStatusBar="True"
OnNeedDataSource="RadGrid1_NeedDataSource"
OnUpdateCommand="RadGrid1_UpdateCommand"
OnInsertCommand="RadGrid1_InsertCommand"
onitemcreated="RadGrid1_ItemCreated"
OnDeleteCommand="RadGrid1_DeleteCommand" OnDetailTableDataBind="RadGrid1_DetailTableDataBind">
<MasterTableView GridLines="None" Width="100%" CommandItemDisplay="Top"
DataKeyNames="Id" AllowAutomaticInserts="True">
<CommandItemTemplate>
<div style="padding: 0 5px;">
<asp:LinkButton ID="LinkButton2" runat="server" CommandName="InitInsert"
Visible ='<%# !RadGrid1.MasterTableView.IsItemInserted %>'>
Add Item</asp:LinkButton>
</div>
</CommandItemTemplate>
<detailtables>
<telerik1:GridTableView runat="server" DataKeyNames="Id" Name="SCCotenants" AllowAutomaticDeletes="true" AllowAutomaticInserts="true"
AllowAutomaticUpdates="true" CommandItemDisplay="Top">
<CommandItemTemplate>
<div style="padding: 0 5px;">
<asp:LinkButton ID="LinkButton2" runat="server" CommandName="InitInsert"
Visible ='<%# !RadGrid1.MasterTableView.IsItemInserted %>'>
Add Cotenant</asp:LinkButton>
</div>
</CommandItemTemplate>
<parenttablerelation>
<telerik1:GridRelationFields DetailKeyField="ShoppingCenterId" MasterKeyField="Id" />
</parenttablerelation>
<rowindicatorcolumn>
<HeaderStyle Width="20px" />
</rowindicatorcolumn>
<expandcollapsecolumn>
<HeaderStyle Width="20px" />
</expandcollapsecolumn>
<Columns>
<telerik1:GridBoundColumn DataField="ShoppingCenterId"
HeaderText="Shopping Center" UniqueName="ShoppingCenterIDColumn" Visible="true" ItemStyle-Wrap="True">
</telerik1:GridBoundColumn>