Hi
I searched to find something about my problem but all I found does not seen to work :<
I have a hierarchical grid with the following definition. The grid is filled in ...NeedsDatasource and the detail table in the ...DetailDataBind and the UI result is very good
I use the following code to export to excel
==> But as result (see in the attached file), the detail lines in excel are are empty :(
I cannot figure why it is not working => I suppose that for some reason, the export cannot get content of the detail table...
Thanks for helping
RadGrid1.ExportSettings.FileName = "ExcelExport";
RadGrid1.ExportSettings.IgnorePaging = true;
RadGrid1.ExportSettings.ExportOnlyData = true;
RadGrid1.ExportSettings.OpenInNewWindow = true;
RadGrid1.MasterTableView.UseAllDataFields = true;
RadGrid1.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
RadGrid1.MasterTableView.HierarchyDefaultExpanded = true;
RadGrid1.MasterTableView.DetailTables[0].HierarchyDefaultExpanded = true;
RadGrid1.MasterTableView.HierarchyLoadMode = GridChildLoadMode.Client;
RadGrid1.MasterTableView.DetailTables[0].HierarchyLoadMode = GridChildLoadMode.Client;
RadGrid1.MasterTableView.GetColumn("Link").Visible = false;
RadGrid1.MasterTableView.ExportToExcel();
<telerik:RadGrid ID="RadGrid1" runat="server" Width="90%" ShowStatusBar="true" AutoGenerateColumns="False"
PageSize="10" AllowSorting="True" AllowMultiRowSelection="True" AllowPaging="True"
OnDetailTableDataBind="RadGrid1_DetailTableDataBind" OnNeedDataSource="RadGrid1_NeedDataSource"
OnPreRender="RadGrid1_PreRender">
<PagerStyle Mode="NumericPages"></PagerStyle>
<MasterTableView Width="100%" DataKeyNames="DocId" AllowMultiColumnSorting="True" AllowPaging="true" UseAllDataFields="true">
<DetailTables>
<telerik:GridTableView DataKeyNames="LineNumber" Name="Lines" Width="100%">
<Columns>
<telerik:GridBoundColumn SortExpression="LineNumber" HeaderText="Invoice line #" HeaderButtonType="TextButton"
DataField="LineNumber">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Description" HeaderText="Description" HeaderButtonType="TextButton"
DataField="Description">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Quantity" HeaderText="Quantity" HeaderButtonType="TextButton"
DataField="Quantity" DataFormatString="{0:0.00}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="SKU" HeaderText="SKU" HeaderButtonType="TextButton"
DataField="SKU">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="UnitPrice" HeaderText="Unit price" HeaderButtonType="TextButton"
DataField="UnitPrice" DataFormatString="{0:0.00}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="TotalAmount" HeaderText="Amount" HeaderButtonType="TextButton"
DataField="TotalAmount" DataFormatString="{0:0.00}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Banner" HeaderText="Banner" HeaderButtonType="TextButton"
DataField="Banner">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="BDF" HeaderText="BDF" HeaderButtonType="TextButton"
DataField="BDF" DataFormatString="{0:0.00}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Q1083" HeaderText="Q1083" HeaderButtonType="TextButton"
DataField="Q1083" DataFormatString="{0:0.00}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Q1084" HeaderText="Q1084" HeaderButtonType="TextButton"
DataField="Q1084" DataFormatString="{0:0.00}">
</telerik:GridBoundColumn>
</Columns>
</telerik:GridTableView>
</DetailTables>
<Columns>
<telerik:GridClientSelectColumn UniqueName="ClientSelectColumn1">
</telerik:GridClientSelectColumn>
<telerik:GridBoundColumn SortExpression="DocumentNumber" HeaderText="Document number" HeaderButtonType="TextButton"
DataField="DocumentNumber">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="ReferenceNumber" HeaderText="Reference number" HeaderButtonType="TextButton"
DataField="ReferenceNumber">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="WeekEnding" HeaderText="Week ending" HeaderButtonType="TextButton"
DataField="WeekEnding" DataFormatString="{0:yyyy-MM-dd}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="StartPeriod" HeaderText="Promo start" HeaderButtonType="TextButton"
DataField="StartPeriod" DataFormatString="{0:yyyy-MM-dd}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="EndPeriod" HeaderText="Promo end" HeaderButtonType="TextButton"
DataField="EndPeriod" DataFormatString="{0:yyyy-MM-dd}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="CostDealNumber" HeaderText="Cost Deal number" HeaderButtonType="TextButton"
DataField="CostDealNumber">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="TotalAmount" HeaderText="Total Amount" HeaderButtonType="TextButton"
DataField="TotalAmount" DataFormatString="{0:0.00}"></telerik:GridBoundColumn>
<telerik:GridHyperLinkColumn HeaderText="Link" ImageUrl="~/Images/lens.png" Target="_blank" UniqueName="Link"
DataNavigateUrlFields= "DocId"
DataNavigateUrlFormatString= "~/dm_detail.aspx?DM_OBJECT_ID={0}">
</telerik:GridHyperLinkColumn>
<telerik:GridBoundColumn SortExpression="CheckNumber" HeaderText="Check #" HeaderButtonType="TextButton"
DataField="CheckNumber">
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
<ClientSettings>
<Selecting AllowRowSelect="true"></Selecting>
</ClientSettings>
</telerik:RadGrid>
I searched to find something about my problem but all I found does not seen to work :<
I have a hierarchical grid with the following definition. The grid is filled in ...NeedsDatasource and the detail table in the ...DetailDataBind and the UI result is very good
I use the following code to export to excel
==> But as result (see in the attached file), the detail lines in excel are are empty :(
I cannot figure why it is not working => I suppose that for some reason, the export cannot get content of the detail table...
Thanks for helping
RadGrid1.ExportSettings.FileName = "ExcelExport";
RadGrid1.ExportSettings.IgnorePaging = true;
RadGrid1.ExportSettings.ExportOnlyData = true;
RadGrid1.ExportSettings.OpenInNewWindow = true;
RadGrid1.MasterTableView.UseAllDataFields = true;
RadGrid1.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
RadGrid1.MasterTableView.HierarchyDefaultExpanded = true;
RadGrid1.MasterTableView.DetailTables[0].HierarchyDefaultExpanded = true;
RadGrid1.MasterTableView.HierarchyLoadMode = GridChildLoadMode.Client;
RadGrid1.MasterTableView.DetailTables[0].HierarchyLoadMode = GridChildLoadMode.Client;
RadGrid1.MasterTableView.GetColumn("Link").Visible = false;
RadGrid1.MasterTableView.ExportToExcel();
<telerik:RadGrid ID="RadGrid1" runat="server" Width="90%" ShowStatusBar="true" AutoGenerateColumns="False"
PageSize="10" AllowSorting="True" AllowMultiRowSelection="True" AllowPaging="True"
OnDetailTableDataBind="RadGrid1_DetailTableDataBind" OnNeedDataSource="RadGrid1_NeedDataSource"
OnPreRender="RadGrid1_PreRender">
<PagerStyle Mode="NumericPages"></PagerStyle>
<MasterTableView Width="100%" DataKeyNames="DocId" AllowMultiColumnSorting="True" AllowPaging="true" UseAllDataFields="true">
<DetailTables>
<telerik:GridTableView DataKeyNames="LineNumber" Name="Lines" Width="100%">
<Columns>
<telerik:GridBoundColumn SortExpression="LineNumber" HeaderText="Invoice line #" HeaderButtonType="TextButton"
DataField="LineNumber">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Description" HeaderText="Description" HeaderButtonType="TextButton"
DataField="Description">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Quantity" HeaderText="Quantity" HeaderButtonType="TextButton"
DataField="Quantity" DataFormatString="{0:0.00}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="SKU" HeaderText="SKU" HeaderButtonType="TextButton"
DataField="SKU">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="UnitPrice" HeaderText="Unit price" HeaderButtonType="TextButton"
DataField="UnitPrice" DataFormatString="{0:0.00}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="TotalAmount" HeaderText="Amount" HeaderButtonType="TextButton"
DataField="TotalAmount" DataFormatString="{0:0.00}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Banner" HeaderText="Banner" HeaderButtonType="TextButton"
DataField="Banner">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="BDF" HeaderText="BDF" HeaderButtonType="TextButton"
DataField="BDF" DataFormatString="{0:0.00}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Q1083" HeaderText="Q1083" HeaderButtonType="TextButton"
DataField="Q1083" DataFormatString="{0:0.00}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Q1084" HeaderText="Q1084" HeaderButtonType="TextButton"
DataField="Q1084" DataFormatString="{0:0.00}">
</telerik:GridBoundColumn>
</Columns>
</telerik:GridTableView>
</DetailTables>
<Columns>
<telerik:GridClientSelectColumn UniqueName="ClientSelectColumn1">
</telerik:GridClientSelectColumn>
<telerik:GridBoundColumn SortExpression="DocumentNumber" HeaderText="Document number" HeaderButtonType="TextButton"
DataField="DocumentNumber">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="ReferenceNumber" HeaderText="Reference number" HeaderButtonType="TextButton"
DataField="ReferenceNumber">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="WeekEnding" HeaderText="Week ending" HeaderButtonType="TextButton"
DataField="WeekEnding" DataFormatString="{0:yyyy-MM-dd}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="StartPeriod" HeaderText="Promo start" HeaderButtonType="TextButton"
DataField="StartPeriod" DataFormatString="{0:yyyy-MM-dd}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="EndPeriod" HeaderText="Promo end" HeaderButtonType="TextButton"
DataField="EndPeriod" DataFormatString="{0:yyyy-MM-dd}">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="CostDealNumber" HeaderText="Cost Deal number" HeaderButtonType="TextButton"
DataField="CostDealNumber">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="TotalAmount" HeaderText="Total Amount" HeaderButtonType="TextButton"
DataField="TotalAmount" DataFormatString="{0:0.00}"></telerik:GridBoundColumn>
<telerik:GridHyperLinkColumn HeaderText="Link" ImageUrl="~/Images/lens.png" Target="_blank" UniqueName="Link"
DataNavigateUrlFields= "DocId"
DataNavigateUrlFormatString= "~/dm_detail.aspx?DM_OBJECT_ID={0}">
</telerik:GridHyperLinkColumn>
<telerik:GridBoundColumn SortExpression="CheckNumber" HeaderText="Check #" HeaderButtonType="TextButton"
DataField="CheckNumber">
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
<ClientSettings>
<Selecting AllowRowSelect="true"></Selecting>
</ClientSettings>
</telerik:RadGrid>