Not able to get childgrid footer total in export to excel

8 posts, 0 answers
  1. Kishore
    Kishore avatar
    7 posts
    Member since:
    Apr 2014

    Posted 23 Apr 2014 Link to this post

    Hi,
         I am not able to get the footer total in child grid total when I export to excel .In excel sheet I am not getting the total in footer.
  2. Tina Stancheva
    Admin
    Tina Stancheva avatar
    3298 posts

    Posted 23 Apr 2014 Link to this post

    Hi Kishore,

    You have posted your question under the Telerik Platform forums. Telerik Platform is a modular platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native apps. It can help you solve the challenges of designing, building, connecting, testing, deploying, managing, publishing, and measuring your applications. 

    However, looking at the question you posted it seems you're either using a UI component from one of our DevTools suites or our Reporting tools. Can you please provide us with more details about the component you're using and the platform it is targeting - ASP.NET AJAX, WPF, etc. Any additional information as well as code snippets describing your issue will be highly appreciated as they will help us better understand your case and issue.
     
    Also, please make sure to post your questions in the respective forums in order to receive relevant response to your queries from the respective community or support specialists.


    Regards,
    Tina Stancheva
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  3. Kishore
    Kishore avatar
    7 posts
    Member since:
    Apr 2014

    Posted 23 Apr 2014 Link to this post

    my question was on telerik radgrid.
  4. Kostadin
    Admin
    Kostadin avatar
    1708 posts

    Posted 28 Apr 2014 Link to this post

    Hello Kishore,

    Thank you for contacting us.

    Could you please elaborate a little bit more on your scenario? Which export format you are using? I would appreciate if you could provide your code declaration and the related code behind in order to investigate the cause for this issue further.

    Regards,
    Kostadin
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  5. Kishore
    Kishore avatar
    7 posts
    Member since:
    Apr 2014

    Posted 29 Apr 2014 in reply to Kostadin Link to this post

    <telerik:RadGrid ID="rg_DataBase" runat="server" Width="99.5%" ShowStatusBar="true"
                            AutoGenerateColumns="False" PageSize="10" AllowSorting="True" AllowMultiRowSelection="False"
                            AllowPaging="True" OnDetailTableDataBind="rg_DataBase_DetailTableDataBind" OnNeedDataSource="rg_DataBase_NeedDataSource" OnItemDataBound="rg_DataBase_ItemDataBound"
                            OnPreRender="rg_DataBase_PreRender" Skin="WebBlue" OnItemCommand="rg_DataBase_ItemCommand" OnExcelMLExportRowCreated="rg_DataBase_ExcelMLExportRowCreated"
                         ShowFooter="false"    >
                            <PagerStyle AlwaysVisible="false"></PagerStyle>
                            <MasterTableView Width="100%" DataKeyNames="FYIDB_ID" AllowMultiColumnSorting="True"
                                CommandItemDisplay="None" ExpandCollapseColumn-Display="true" >
                                <CommandItemSettings ShowExportToExcelButton="true"  ShowAddNewRecordButton="false">
                                </CommandItemSettings>
                                <DetailTables>
                                    <telerik:GridTableView  DataKeyNames="FYIDB_ID" Name="Volumes" Width="100%" SkinID="Vista" ShowFooter="true"    >
                                        <HeaderStyle CssClass="MostInnerHeaderStyle" />
                                        <FooterStyle CssClass="MostInnerHeaderStyle" />
                                        <%-- <ItemStyle CssClass="MostInnerItemStyle" />--%>
                                        <Columns>
                                            <telerik:GridBoundColumn SortExpression="FYIVOL_VolumeName" HeaderStyle-HorizontalAlign="Center"
                                                HeaderText="Name" HeaderButtonType="TextButton" DataField="FYIVOL_VolumeName"
                                                ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="10%">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn SortExpression="ETPT_Number" HeaderStyle-HorizontalAlign="Center"
                                                HeaderText="ETPT" HeaderButtonType="TextButton" DataField="ETPT_Number" UniqueName="ETPT_Number"
                                                ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="10%">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn SortExpression="SERIAL NUMBER" HeaderStyle-HorizontalAlign="Center"
                                                HeaderText="Serial#" HeaderButtonType="TextButton" DataField="SERIAL NUMBER"
                                                UniqueName="SERIALNUMBER" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="10%">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn SortExpression="Contact_ID" HeaderStyle-HorizontalAlign="Center"
                                                HeaderText="Received From" HeaderButtonType="TextButton" DataField="Contact_ID"
                                                UniqueName="Contact_ID" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="10%">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn SortExpression="FYIVOL_BatesRange" HeaderStyle-HorizontalAlign="Center"
                                                HeaderText="Bates Range" HeaderButtonType="TextButton" DataField="FYIVOL_BatesRange"
                                                UniqueName="FYIVOL_BatesRange" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="15%">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn SortExpression="FYIVOL_DocCount" HeaderStyle-HorizontalAlign="Center"
                                                HeaderText="Docs" HeaderButtonType="TextButton" DataField="FYIVOL_DocCount" UniqueName="FYIVOL_DocCount"
                                                ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="10%">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn SortExpression="FYIVOL_PageCount" HeaderStyle-HorizontalAlign="Center"
                                                HeaderText="Pages" HeaderButtonType="TextButton" DataField="FYIVOL_PageCount"
                                                UniqueName="FYIVOL_PageCount" ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="10%">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn SortExpression="FYIVOL_DateLoade" HeaderStyle-HorizontalAlign="Center"
                                                HeaderText="Date Loaded" HeaderButtonType="TextButton" DataField="FYIVOL_DateLoade"
                                                UniqueName="FYIVOL_DateLoade" ItemStyle-HorizontalAlign="Center" HeaderStyle-Width="10%">
                                            </telerik:GridBoundColumn>
                                            <telerik:GridBoundColumn SortExpression="FYIVOL_Size" HeaderStyle-HorizontalAlign="Center"
                                                HeaderText="Size" HeaderButtonType="TextButton" DataField="FYIVOL_Size" UniqueName="FYIVOL_Size"
                                                ItemStyle-HorizontalAlign="Right" HeaderStyle-Width="15%" FooterStyle-HorizontalAlign="Right">
                                            </telerik:GridBoundColumn>
     
                                           <%-- <telerik:GridCalculatedColumn HeaderText="Total Price" UniqueName="Size" DataType="System.Double"
                        DataFields="Size" Expression="{0}" FooterText="Total : "
                        Aggregate="Sum" />--%>
                                        </Columns>
                                    </telerik:GridTableView>
                                </DetailTables>
                                <Columns>
                                    <telerik:GridBoundColumn SortExpression="FYIDB_Name" HeaderStyle-HorizontalAlign="Center"
                                        HeaderText="Name" HeaderButtonType="TextButton" DataField="FYIDB_Name" ColumnGroupName="rgcg_Name"
                                        ItemStyle-HorizontalAlign="Center">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn SortExpression="FYIDB_DateCreate" HeaderStyle-HorizontalAlign="Center"
                                        HeaderText="Date Created" HeaderButtonType="TextButton" DataField="FYIDB_DateCreate"
                                        ColumnGroupName="rgcg_Name" ItemStyle-HorizontalAlign="Center">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn SortExpression="FYIDB_Status" HeaderStyle-HorizontalAlign="Center"
                                        HeaderText="Status" HeaderButtonType="TextButton" DataField="FYIDB_Status" ColumnGroupName="rgcg_Name"
                                        ItemStyle-HorizontalAlign="Center">
                                    </telerik:GridBoundColumn>
                                    <telerik:GridBoundColumn SortExpression="FYIDB_StatusDateChange" HeaderStyle-HorizontalAlign="Center"
                                        HeaderText="Status Changed" HeaderButtonType="TextButton" DataField="FYIDB_StatusDateChange"
                                        ColumnGroupName="rgcg_Name" ItemStyle-HorizontalAlign="Center">
                                    </telerik:GridBoundColumn>
                                </Columns>
                            </MasterTableView>
                            <ClientSettings EnableRowHoverStyle="true" EnablePostBackOnRowClick="false">
                                <Selecting AllowRowSelect="true" EnableDragToSelectRows="false" />
                                <Resizing AllowColumnResize="True" AllowRowResize="false" ResizeGridOnColumnResize="true"
                                    ClipCellContentOnResize="false" EnableRealTimeResize="false" AllowResizeToFit="true" />
                            </ClientSettings>
                            <ExportSettings ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true"
                                FileName="Elijah_Hosting_Databases Information">
                                <Excel Format="ExcelML" />
                            </ExportSettings>
                        </telerik:RadGrid>



    hi kastadin,

             I am sending the grid design.i want the inner grid total when I export to excel. I am getting total in my application.




  6. Eyup
    Admin
    Eyup avatar
    3005 posts

    Posted 06 May 2014 Link to this post

    Hello Kishore,

    Please try setting the following format:
    <Excel Format="Html" />

    This should resolve the issue. Please give it a try and let me know about the result.

    Regards,
    Eyup
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
  7. Kishore
    Kishore avatar
    7 posts
    Member since:
    Apr 2014

    Posted 07 May 2014 in reply to Eyup Link to this post

    hi,
       Thank you eyup now inner grid footer value is coming but the excel sheet lines disappearing. Is there any to get the excel lines.
  8. Eyup
    Admin
    Eyup avatar
    3005 posts

    Posted 12 May 2014 Link to this post

    Hello Kishore,

    You can try adding the following logic:
    protected void rg_DataBase_ItemCommand(object sender, GridCommandEventArgs e)
    {
        if (e.CommandName == RadGrid.ExportToExcelCommandName)
        {
            rg_DataBase.GridLines = GridLines.Both;
        }
    }

    Alternatively, you can check the following post:
    http://www.telerik.com/forums/radgrid-doesnt-export-grid-footer-to-excel-excelml#slPUWDfqj02dfZG6VslKDA

    Hope this helps.

    Regards,
    Eyup
    Telerik
     

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

     
Back to Top