Problem in total sum in Radgrid Grouping

[Jiten]

Hello,

I have a problem in Grouping and show  total of coulmn. Here is the RadGrid control:
 
   <telerik:RadGrid ID="gvDetails" runat="server" Width="100%" Height="570px" Skin="Hay"
                                AllowPaging="false" AllowSorting="true" PageSize="10" GridLines="None" AllowMultiRowSelection="false"
                                OnItemDataBound="gvDetails_ItemDataBound" OnPreRender="gvDetails_PreRender" OnColumnCreated="gvDetails_ColumnCreated"
                                OnItemCommand="gvDetails_ItemCommand" OnGroupsChanging="gvDetails_OnGroupsChanging"
                                ShowFooter="True" ShowGroupPanel="true">
                                <PagerStyle Mode="NextPrevAndNumeric" />
                                <FooterStyle Font-Bold="true" />
                                <HeaderStyle Font-Bold="true" />
                                <ClientSettings AllowColumnsReorder="true" AllowDragToGroup="true">
                                    <Selecting AllowRowSelect="true" UseClientSelectColumnOnly="true" />
                                    <Scrolling AllowScroll="true" UseStaticHeaders="true" />
                                    <Resizing AllowRowResize="True" EnableRealTimeResize="True" ResizeGridOnColumnResize="True"
                                        AllowColumnResize="True"></Resizing>
                                </ClientSettings>
                                <GroupingSettings CaseSensitive="false" RetainGroupFootersVisibility="true" ShowUnGroupButton="true" />
                                <ExportSettings>
                                    <Pdf PageTitle="My Page" PaperSize="A4" />
                                </ExportSettings>
                                <MasterTableView Width="100%" TableLayout="Auto" CellSpacing="-1" GroupLoadMode="Client" AllowFilteringByColumn="true"
                                    CommandItemDisplay="TopAndBottom" ShowGroupFooter="true" AllowMultiColumnSorting="true"
                                    CommandItemSettings-ShowAddNewRecordButton="false">
                                    <CommandItemSettings ShowExportToCsvButton="true" ShowExportToPdfButton="true" />
                                    <NoRecordsTemplate>
                                        <div style="font-weight: bold; color: Red;">
                                            No Record Found.</div>
                                    </NoRecordsTemplate>
                                </MasterTableView>
                            </telerik:RadGrid>


And in behind Code, I bind from the Procedure in Dataset:


            gvDetails.DataSource = ds.Tables[0];
            gvDetails.DataBind();


How i can do to display the total sum to every column which display in the radgrid control.

i also check the following link:

http://www.telerik.com/help/aspnet-ajax/grid-perform-calculations-in-group-header.html
http://www.telerik.com/community/forums/aspnet-ajax/grid/radgrid-group-totals-for-dynamic-columns.aspx

http://www.telerik.com/community/forums/aspnet-ajax/grid/radgrid-grouping-with-calculated-subtotals.aspx

http://demos.telerik.com/aspnet-ajax/grid/examples/groupby/groupfooter/defaultcs.aspx

But I don't find any solution.


Please help me as soon as possible.

Thanks

Best Regards

Jiten Mutum

[Antonio Stoilkov]

Hello Jiten,

In order to resolve your problem you should use advanced data-binding approach or use declarative data source instead of simple data-binding which as described in the help article below does not support grouping functionality.

• Simple Data-binding

Greetings,
Antonio Stoilkov
the Telerik team