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

Group Aggregate incorrect and footertext not showing

10 Answers 473 Views

Grid

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

Jon Ingersoll asked on 21 Apr 2010, 05:54 PM

I'm having two issues with my radgrid

1) I have a aggregate group column that instead of showing the sum of the column is showing the last value in column.
2) Since the grouping wasn't working I turned on the groupfooters to show the aggregate sum, but the FooterText is not showing in the footer.

As far as I can tell, I've followed the demos exactly to use both those features.

I've attached a screen shot of the output, notice in the group header that the sum of the cost is wrong and in the footer while the cost sum is correct, the text "Total: " isn't showing.

-Jon

    
            <%@ Control Language="C#" AutoEventWireup="true" CodeFile="GuestAdmin.ascx.cs" Inherits="GuestAdmin" %> 
        
            <%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %> 
        
            <telerik:RadGrid ID="GridReunionGuests" AllowFilteringByColumn="False" AllowPaging="True" 
        
                Skin="Vista" AllowSorting="False" runat="server" AutoGenerateColumns="False" 
        
                DataSourceID="ReunionGuestsDataSource" GroupingEnabled="true"> 
        
                <MasterTableView DataKeyNames="ReunionGuestsID" DataSourceID="ReunionGuestsDataSource" ShowGroupFooter="true"> 
        
                    <Columns> 
        
                        <telerik:GridBoundColumn DataField="FirstName" HeaderText="First" /> 
        
                        <telerik:GridBoundColumn DataField="LastName" HeaderText="Last" /> 
        
                        <telerik:GridBoundColumn DataField="Age" HeaderText="Age" /> 
        
                        <telerik:GridDropDownColumn DataField="GuestOptionsID" DataSourceID="GuestOptionsDataSource" 
        
                            HeaderText="Options" ListTextField="GuestOption" ListValueField="GuestOptionsID" 
        
                            UniqueName="GuestOption"> 
        
                        </telerik:GridDropDownColumn> 
        
                        <telerik:GridDropDownColumn DataField="RelationShipsID" DataSourceID="RelationShipsDataSource" 
        
                            HeaderText="Relationship" ListTextField="Description" ListValueField="RelationShipsID" 
        
                            UniqueName="RelationShip"> 
        
                        </telerik:GridDropDownColumn> 
        
                        <telerik:GridBoundColumn DataField="SpecialRequirements" HeaderText="Special Requirements" /> 
        
                        <telerik:GridBoundColumn DataField="ReunionYear" HeaderText="Reunion" /> 
        
                        <telerik:GridBoundColumn DataField="DateStamp" HeaderText="Date Stamp" /> 
        
                        <telerik:GridDropDownColumn DataField="RegStatusID" DataSourceID="RegStatusDataSource" 
        
                            HeaderText="Status" ListTextField="RegistrationStatus" ListValueField="RegStatusID" 
        
                            UniqueName="Status"> 
        
                        </telerik:GridDropDownColumn> 
        
                        <telerik:GridBoundColumn DataField="Cost" HeaderText="Cost" FooterText="Total: " Aggregate="Sum" DataFormatString="{0:C}" ItemStyle-HorizontalAlign="Right" DataType="System.Double" /> 
        
                    </Columns> 
        
                    <GroupByExpressions> 
        
                                    <telerik:GridGroupByExpression> 
        
                                        <SelectFields> 
        
                                            <telerik:GridGroupByField HeaderText="Transaction ID" FieldName="transactiongroup"></telerik:GridGroupByField> 
        
                                            <telerik:GridGroupByField FieldName="Email"></telerik:GridGroupByField> 
        
                                            <telerik:GridGroupByField HeaderText="Customer ID" FieldName="CUSTID"></telerik:GridGroupByField> 
        
                                            <telerik:GridGroupByField HeaderText="Cost" FieldName="Cost" Aggregate="Sum"></telerik:GridGroupByField> 
        
                                         </SelectFields> 
        
                                        <GroupByFields> 
        
                                            <telerik:GridGroupByField FieldName="transactiongroup"></telerik:GridGroupByField> 
        
                                        </GroupByFields> 
        
                                    </telerik:GridGroupByExpression> 
        
                                </GroupByExpressions> 
        
                </MasterTableView> 
        
            </telerik:RadGrid> 
        
            <asp:SqlDataSource ID="ReunionGuestsDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:edu_yale_som_alumnireunion_connectionstring %>" 
        
                ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [ReunionGuests] WHERE Submitted='true'"> 
        
            </asp:SqlDataSource> 
        
            <asp:SqlDataSource ID="GuestOptionsDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:edu_yale_som_alumnireunion_connectionstring %>" 
        
                ProviderName="System.Data.SqlClient" SelectCommand="SELECT [GuestOptionsID], [GuestOption] FROM [GuestOptions] WHERE Visible='true' order by DisplayOrder"> 
        
            </asp:SqlDataSource> 
        
            <asp:SqlDataSource ID="RelationShipsDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:edu_yale_som_alumnireunion_connectionstring %>" 
        
                ProviderName="System.Data.SqlClient" SelectCommand="SELECT [RelationShipsID], [Description] FROM [RelationShips]"> 
        
            </asp:SqlDataSource> 
        
            <asp:SqlDataSource ID="RegStatusDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:edu_yale_som_alumnireunion_connectionstring %>" 
        
                ProviderName="System.Data.SqlClient" SelectCommand="SELECT [RegStatusID], [RegistrationStatus] FROM [RegStatus]"> 
        
            </asp:SqlDataSource>

10 Answers, 1 is accepted

answered on 14 Oct 2010, 02:38 PM

Hi Pavlina,

I'm aware of how to manually do the calculations, but my question was more of pointing out there is a bug or issue with the way the radgrid is doing aggregates on grouped columns. Please note my issue is occurring not in the footer, but in the grouping text. When you set the Aggregate mode to "Sum" and it doesn't "Sum", but instead gives only the value of the last record, thats a bug or problem. My work around is to do it manually as I still need to get my work done, but this becomes a pain with many groups or columns when the radgrid control is already suppose to cover this functionality; Which the radgrid does... it just doesn't do it correctly. If Telerik cannot duplicate this issue, I can try to send a sample project when I wrap up what I'm working on in two weeks.

Thanks for looking into it and your previous response.

-Jeremy

answered on 10 Nov 2010, 04:10 PM

Hello Fred,

In order to show the totals in group header FieldAlias property should be set for the SelectFields as shown below:
ASPX:

<SelectFields>

<telerik:GridGroupByField

FieldName="UnitsInStock"

FieldAlias="FieldAlias1"

HeaderText="Units at this price"

Aggregate="Sum" />

</SelectFields>

Give it a try and let me know how it goes.

Kind regards,
Pavlina
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

answered on 10 Nov 2010, 09:26 PM

lastrow.JPG

groupheader.JPG

This still doesn't work. I am also having issues with Group Aggregates only showing the value of the last record of that group.

I simply do this code in the background:

string var = "SalesRep [Sales Rep], count(RecordNum) RecordNum [Count], Sum(TotalSplit) TotalSplit [Total Split] Group By SalesRep";

grdBillings.MasterTableView.GroupByExpressions.Add(GridGroupByExpression.Parse(var));

grdBillings.Rebind();

TABLE FOOTER aggregates work just fine.

answered on 10 Nov 2010, 09:53 PM

I'm replying to my own question since I have figured out the issue.

I have identified how fix the problem in two different situations.

When setting a group Aggregate in the code behind... The FIELD ALIAS SHOULD NOT MATCH the name of the FieldName. This will screw things up. So this code is wrong.

GridGroupByField agg = new GridGroupByField();

agg.FieldName = "Amount"

agg.FieldAlias = "Amount";

agg.Aggregate = GridAggregateFunction.Sum

agg.FormatString = "{0:c}"

agg.HeaderValueSeparator = ":";

This is right (note FieldAlias is different. Furthermore, do not use special characters in FieldAlias, program will crash):

GridGroupByField agg = new GridGroupByField();

agg.FieldName = "Amount"

agg.FieldAlias = "TotalAmount";

agg.Aggregate = GridAggregateFunction.Sum

agg.FormatString = "{0:c}"

agg.HeaderValueSeparator = ":";

Now, for the String based expression, when doing an Aggregate, use a column name that does not exist in your data.

For example, this is wrong:

string var = "SalesRep [Sales Rep], count(RecordNum) RecordNum [Count], Sum(TotalSplit) TotalSplit [Total Split] Group By SalesRep";

This is right:

string var = "SalesRep [Sales Rep], count(RecordNum) MadeUp [Count], Sum(TotalSplit) DoesntExist[Total Split] Group By SalesRep";

Noticed I placed made up column names in the last string.

Hope this information helps.