Sum in Group Header and Grid Footer

[Adam Pehas]

I'm having an issue with the Aggergate="Sum"  I have a bunch of invoices with fees on them.  I needs to display the data grouped by invoice and show the total of the fees in the group header along with a Grand total in the footer of the entire grid. 

I'm using the following markup to do that.  The issue is that when I include the SUM for the grand total in the footer.  The Group header will only show the value of the last item in that group.  The group header no longer rolls or sums up the fees in the group.

<telerik:RadGrid ID="rgFees" runat="server" AutoGenerateColumns="false" ShowFooter="True"

    Skin="Web20" Height="500px">

    <ClientSettings>

        <Scrolling AllowScroll="True" UseStaticHeaders="True" />

    </ClientSettings>

    <MasterTableView ShowGroupFooter="true" AllowMultiColumnSorting="true" GroupLoadMode="Client">

        <Columns>

            <telerik:GridBoundColumn DataField="FeeDescription" HeaderText="Fee Description">

            </telerik:GridBoundColumn>

  

             <telerik:GridBoundColumn Aggregate="Sum" DataField="TotalFee" HeaderText="Total*"

                FooterText="Total" DataFormatString="{0:C}">

            </telerik:GridBoundColumn>      

  

            <telerik:GridBoundColumn DataField="InvoiceId" HeaderText="Invoice Number">

            </telerik:GridBoundColumn>

        </Columns>

        <GroupByExpressions>

            <telerik:GridGroupByExpression>

                <GroupByFields>

                    <telerik:GridGroupByField FieldName="InvoiceId" HeaderText="" />

                </GroupByFields>

                <SelectFields>

                    <telerik:GridGroupByField FieldName="InvoiceId" HeaderText="  " HeaderValueSeparator="Invoice # " />

                    <telerik:GridGroupByField FieldName="TotalFee" HeaderText="            "

                        HeaderValueSeparator="Total: " Aggregate="Sum" FormatString="{0:C}" />

                </SelectFields>

            </telerik:GridGroupByExpression>

        </GroupByExpressions>

    </MasterTableView>

    <ClientSettings AllowDragToGroup="false" />

    <GroupingSettings ShowUnGroupButton="false" />

</telerik:RadGrid>





The following Code works and gives the correct group header sum.  How do I get a GRAND TOTAL to show up in the footer for the entire grid.

<telerik:RadGrid ID="rgFees" runat="server" AutoGenerateColumns="false" ShowFooter="True"
    Skin="Web20" Height="500px">
    <ClientSettings>
        <Scrolling AllowScroll="True" UseStaticHeaders="True" />
    </ClientSettings>
    <MasterTableView ShowGroupFooter="true" AllowMultiColumnSorting="true" GroupLoadMode="Client">
        <Columns>
            <telerik:GridBoundColumn DataField="FeeDescription" HeaderText="Fee Description">
            </telerik:GridBoundColumn>

             <telerik:GridBoundColumn   DataField="TotalFee" HeaderText="Total*"
                FooterText="Total" DataFormatString="{0:C}">
            </telerik:GridBoundColumn>

            <telerik:GridBoundColumn DataField="InvoiceId" HeaderText="Invoice Number">
            </telerik:GridBoundColumn>
        </Columns>
        <GroupByExpressions>
            <telerik:GridGroupByExpression>
                <GroupByFields>
                    <telerik:GridGroupByField FieldName="InvoiceId" HeaderText="" />
                </GroupByFields>
                <SelectFields>
                    <telerik:GridGroupByField FieldName="InvoiceId" HeaderText="  " HeaderValueSeparator="Invoice # " />
                    <telerik:GridGroupByField FieldName="TotalFee" HeaderText="            "
                        HeaderValueSeparator="Total: " Aggregate="Sum" FormatString="{0:C}" />
                </SelectFields>
            </telerik:GridGroupByExpression>
        </GroupByExpressions>
    </MasterTableView>
    <ClientSettings AllowDragToGroup="false" />
    <GroupingSettings ShowUnGroupButton="false" />
</telerik:RadGrid>

[Pavlina]

Hello Adam,

I suggest that you examine the online resources below and see if they help:
http://demos.telerik.com/aspnet-ajax/grid/examples/groupby/groupfooter/defaultcs.aspx
http://www.telerik.com/help/aspnet-ajax/grdperformcalculationsingroupheader.html

All the best,
Pavlina
the Telerik team

[Jaicon]

This work fine for me:

     protected void RadGrid1_PreRender(object sender, EventArgs e)
        {
            foreach (GridGroupFooterItem groupFooter in RadGrid1.MasterTableView.GetItems(GridItemType.GroupFooter))
            {
                string value = groupFooter["uniqueName"].Text;

                foreach (GridGroupHeaderItem groupHeader in RadGrid1.MasterTableView.GetItems(GridItemType.GroupHeader))
                {
                    if (groupHeader.GroupIndex == groupFooter.GroupIndex)
                    {
                        groupHeader.DataCell.Text += " " + value;
                    }
                }
            }
        }

[Pavlina]

Hello Jaicon,

Thank you for sharing your solution with the community.

Regards,
Pavlina
Telerik