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

Paging: Group Aggregate For All Data Rows

1 Answer 44 Views
Grid
This is a migrated thread and some comments may be shown as answers.
G.
Top achievements
Rank 1
G. asked on 04 Jun 2012, 09:08 PM

I have a RadGrid configured with Paging and Grouping with Aggregates
- AllowPaging = true
- ShowGroupFooter = true
- RetainGroupFootersVisibility=true

 

 

 

 

<telerik:GridGroupByExpression>
    <GroupByFields>
        <telerik:GridGroupByField FieldName="A" SortOrder="Ascending" HeaderText="A" />
    </GroupByFields>
</telerik:GridGroupByExpression>

I have 1 column defined as Aggregate

 

<telerik:GridBoundColumn AllowFiltering="False" SortExpression="Amount"
    DataField="Amount"  DataFormatString="{0:C2}" Groupable="False" HeaderText="Amount"
    ReadOnly="True" Reorderable="False" Resizable="False" UniqueName="Amount"
    Aggregate="Sum">
</telerik:GridBoundColumn>

Problem

The RadGrid, by default, appears to Aggregate for items in the current page (i.e. The Grouping Total that appears in the GroupFooter... only applies to visible items on the currently selected page (even when the group extends into other pages).

Question

How can I implement a custom aggregate in which I sum all of the values for a particular column within a group (across all data items that are in the group / i.e. across all pages)? 




1 Answer, 1 is accepted

Sort by
0
Preston
Top achievements
Rank 1
answered on 09 Aug 2012, 08:31 PM
I am having the same problem.  Please let me know if you find a solution.  

Thank you.
Tags
Grid
Asked by
G.
Top achievements
Rank 1
Answers by
Preston
Top achievements
Rank 1
Share this question
or