This is a migrated thread and some comments may be shown as answers.

Not able to get childgrid footer total in export to excel

7 Answers 54 Views
Sample Applications
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Kishore
Top achievements
Rank 1
Kishore asked on 23 Apr 2014, 11:39 AM
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.

7 Answers, 1 is accepted

Sort by
0
Tina Stancheva
Telerik team
answered on 23 Apr 2014, 11:52 AM
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.

 
0
Kishore
Top achievements
Rank 1
answered on 23 Apr 2014, 12:02 PM
my question was on telerik radgrid.
0
Kostadin
Telerik team
answered on 28 Apr 2014, 07:05 AM
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.

 
0
Kishore
Top achievements
Rank 1
answered on 29 Apr 2014, 12:57 PM
<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.




0
Eyup
Telerik team
answered on 06 May 2014, 12:53 PM
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.

 
0
Kishore
Top achievements
Rank 1
answered on 07 May 2014, 09:03 AM
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.
0
Eyup
Telerik team
answered on 12 May 2014, 08:11 AM
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.

 
Tags
Sample Applications
Asked by
Kishore
Top achievements
Rank 1
Answers by
Tina Stancheva
Telerik team
Kishore
Top achievements
Rank 1
Kostadin
Telerik team
Eyup
Telerik team
Share this question
or