[Solved] RadGrid Aggregate Issue

[steve johnson]

Hey.  I'm having an issue with a grid which uses a hierarchical structure along with aggregates on a column.  The front end code looks like this:

<MasterTableView>
   <DetailTables>
      <telerik:GridTableView ShowFooter="true">
         <ParentTableRelation>etc...</ParentTableRelation>
            <Columns>
               <telerik:GridBoundColumn HeaderText="Affiliate" DataField="affiliate"/>
               <telerik:GridBoundColumn HeaderText="Records Received" DataField = "RecordCount" Aggregate="Sum" UniqueName="RecordCount" DataFormatString="{0:N0}"/>
            </Columns>
            <DetailTables>
               <telerik:GridTableView ShowFooter="true" GridLines="None" runat="server" Name="Data" FooterStyle-ForeColor="White">
                       <ParentTableRelation>etc...</ParentTableRelation>
                  <Columns>
                    <telerik:GridBoundColumn DataField="SubID" HeaderText="SubID" UniqueName="SubID" />
                     <telerik:GridBoundColumn HeaderText="Record Count" DataField="Record Count" ="Record Count" DataFormatString="{0:N0}" />
                  </Columns>
                </telerik:GridTableView>
              </DetailTables>
         </telerik:GridTableView>
        </DetailTables>
       <Columns>
         etc...
       </Columns>
</MasterTableView>

The data is related properly between the nested tables.  I am attempting to aggregate the Topmost "recordcount" column such that each child table displays the total count for that child in the footer.  The problem is that... the footer is displaying the total count for the entire table.  For example, the first child table might have 1000 records, the second 2000, and the third 3000.  Each footer displays "6000" instead of 1000, 2000, and 3000.  Am I doing something wrong?

[Peter]

Hi,

Can you share with us, how you aggregate the count of the items? I could not see anything Aggregate property set.

Greetings,
Petar