Radgrid Group Total

[Prathap Narravula]

I had a profit and loss sheet displaying in radgrid.. I want to display the total credit and debit for each group. Can you have any solution to display totals for every group in Radgrid
Please find the attachment for better understanding of my problem

[Princy]

Hello Prathap,

You can set ShowGroupFooter property as true and Aggregate as Sum for each columns. Here is the sample code.
aspx:

<telerik:RadGrid ShowGroupPanel="true" AutoGenerateColumns="false" ID="RadGrid1" DataSourceID="SqlDataSource1" AllowFilteringByColumn="True" AllowSorting="True" ShowFooter="True" runat="server">
  <MasterTableView ShowGroupFooter="true">
    <Columns>
      <telerik:GridBoundColumn Aggregate="Sum" DataField="ProductID" HeaderText="Product ID" FooterText="Total: "></telerik:GridBoundColumn>
      <telerik:GridBoundColumn Aggregate="Sum" DataField="UnitPrice" HeaderText="Unit price" FooterText="Total: "></telerik:GridBoundColumn>
    </Columns>
 <GroupByExpressions>
  <telerik:GridGroupByExpression>
   <GroupByFields>
     <telerik:GridGroupByField FieldName="UnitPrice" />
   </GroupByFields>
   <SelectFields>
      <telerik:GridGroupByField FieldName="UnitPrice" HeaderText="Unit price" />
  </SelectFields>
 </telerik:GridGroupByExpression>
 </GroupByExpressions>
 </MasterTableView>
</telerik:RadGrid>

Thanks,
Princy.