[Solved] Not able to get childgrid footer total in export to excel

[Kishore]

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.

[Tina Stancheva]

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

 

 

[Kishore]

my question was on telerik radgrid.

[Kostadin]

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

 

 

[Kishore]

<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.






[Eyup]

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

 

 

[Kishore]

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.

[Eyup]

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