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

Grouping Footer Total

3 Answers 169 Views

Grid

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

Mehmet asked on 27 Mar 2015, 06:57 AM

screen-shot-2015-03-27-at-5-53-57-pm.png

Hi there,

I am trying to get the total items onto the footer at the bottom, however, I cannot make it when I do grouping based on a jobID.
I've attached my grid's look. It has got the each item's total, however, I want to have the last total at the bottom.
thank you

html code:

<telerik:RadGrid AutoGenerateColumns="False" ID="RadGrid4" AllowFilteringByColumn="True" AllowSorting="True" runat="server" OnItemCommand="RadGrid4_ItemCommand" OnItemCreated="RadGrid4_ItemCreated" EnableLinqExpressions="false" HtmlEncode="true" OnNeedDataSource="RadGrid4_NeedDataSource" GroupingSettings-RetainGroupFootersVisibility="true"

ShowGroupPanel="True" CellSpacing="-1" GridLines="Both" Skin="Office2010Silver" EnableViewState="true" Width="100%">

<PagerStyle Mode="NextPrevAndNumeric" />

<GroupingSettings CaseSensitive="false" />

<ClientSettings AllowKeyboardNavigation="true">

</ClientSettings>

<ExportSettings OpenInNewWindow="true" FileName="i-Dispatch Job Part Used Report" ExportOnlyData="true">

<Pdf PageHeight="210mm" PageWidth="297mm" DefaultFontFamily="Arial Unicode MS" PageTopMargin="45mm"

BorderStyle="Medium" BorderColor="#666666" PaperSize="A4" >

</Pdf>

</ExportSettings>

<MasterTableView Width="100%" DataKeyNames="JobID" HierarchyLoadMode="ServerOnDemand" ShowGroupFooter="true" AllowMultiColumnSorting="true">

<Columns>

<telerik:GridMaskedColumn DataField="JobID" HeaderText="JobID#"

FilterControlWidth="50px" AutoPostBackOnFilter="false" CurrentFilterFunction="EqualTo"

FilterDelay="2000" ShowFilterIcon="false" Mask="#####" GroupByExpression="JobID Group By JobID">

<ColumnValidationSettings>

<ModelErrorMessage Text=""></ModelErrorMessage>

</ColumnValidationSettings>

</telerik:GridMaskedColumn>

<telerik:GridBoundColumn DataField="JobTitle" FilterControlAltText="Filter JobTitle column" HeaderText="Job Title" SortExpression="JobTitle" UniqueName="JobTitle">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

</telerik:GridBoundColumn>

<telerik:GridDateTimeColumn DataField="JobBookedDate" PickerType="DatePicker" EnableTimeIndependentFiltering="true"

DataFormatString="{0:dd/MM/yyyy HH:mm }" DataType="System.DateTime" FilterControlAltText="Filter JobBookedDate column" HeaderText="Job Booked Date" SortExpression="JobBookedDate" UniqueName="JobBookedDate">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

</telerik:GridDateTimeColumn>

<telerik:GridTemplateColumn DataField="AssignedStaffID" HeaderText="Mobile Staff" UniqueName="AssignedStaffID"

HeaderStyle-Width="200px" SortExpression="AssignedStaffID">

<FilterTemplate>

<telerik:RadComboBox ID="comboStaff" DataTextField="StaffName"

DataValueField="StaffID" Height="100px" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("AssignedStaffID").CurrentFilterValue %>'

runat="server" OnClientSelectedIndexChanged="StaffIndexChanged">

<Items>

<telerik:RadComboBoxItem Text="All" />

</Items>

</telerik:RadComboBox>

<telerik:RadScriptBlock ID="RadScriptBlock10" runat="server">

<script type="text/javascript">

function StaffIndexChanged(sender, args) {

var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");

tableView.filter("AssignedStaffID", args.get_item().get_value(), "EqualTo");

}

</script>

</telerik:RadScriptBlock>

</FilterTemplate>

<ItemTemplate>

<%# Eval("Staff") %>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="CreatedBy" HeaderText="Added By" UniqueName="CreatedBy"

HeaderStyle-Width="200px" SortExpression="CreatedBy">

<FilterTemplate>

<telerik:RadComboBox ID="comboAdded" DataTextField="StaffName"

DataValueField="StaffID" Height="100px" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("CreatedBy").CurrentFilterValue %>'

runat="server" OnClientSelectedIndexChanged="AddedByIndexChanged">

<Items>

<telerik:RadComboBoxItem Text="All" />

</Items>

</telerik:RadComboBox>

<telerik:RadScriptBlock ID="RadScriptBlock11" runat="server">

<script type="text/javascript">

function AddedByIndexChanged(sender, args) {

var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");

tableView.filter("CreatedBy", args.get_item().get_value(), "EqualTo");

}

</script>

</telerik:RadScriptBlock>

</FilterTemplate>

<ItemTemplate>

<%# Eval("AddedBy") %>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="PartCode" FilterControlAltText="Filter PartCode column" HeaderText="Part Code" SortExpression="PartCode" UniqueName="PartCode">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="PartName" FilterControlAltText="Filter PartName column" HeaderText="Part Name" SortExpression="PartName" UniqueName="PartName">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

</telerik:GridBoundColumn>

<telerik:GridNumericColumn DataFormatString="{0:$###,##0.00}" DataField="PartPurchasePrice" DataType="System.Double" NumericType="Currency"

HeaderText="PurchasePrice" SortExpression="PartPurchasePrice" UniqueName="PartPurchasePrice" Aggregate="Sum" FooterAggregateFormatString="{0:C}">

<FooterStyle Font-Bold="true"></FooterStyle>