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

Export hierarchical grid with complete data

11 Answers 511 Views

Grid

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

Murad Ajani asked on 05 Sep 2009, 02:34 AM

I am trying export all detail tables and the main grid data. The problem is that it only exports the main grid data if the detail grids are not expanded. Below is the export code. How do I expand all items in order to export complete data?

Private Sub btnExport_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnExport.Click

'LoopHierarchyRecursive(grdEmpData.MasterTableView)

grdEmpData.MasterTableView.HierarchyDefaultExpanded =

True

'grdEmpData.MasterTableView.Rebind()

grdEmpData.ExportSettings.ExportOnlyData =

True

'grdEmpData.ExportSettings.IgnorePaging = True

grdEmpData.MasterTableView.AllowPaging =

False

grdEmpData.ExportSettings.OpenInNewWindow =

True

grdEmpData.ExportSettings.FileName =

"SAPDataList"

grdEmpData.MasterTableView.ExportToExcel()
End Sub

Sub LoopHierarchyRecursive(ByVal gridTableView As GridTableView)

For Each nestedViewItem As GridNestedViewItem In gridTableView.GetItems(GridItemType.NestedView)

nestedViewItem.Expanded = True

If nestedViewItem.NestedTableViews.Length > 0 Then

'now you can access: nestedViewItem.NestedTableViews[0].Items, which will be the DataItems of this nested table

'then make recursive call

LoopHierarchyRecursive(nestedViewItem.NestedTableViews(0))

' above [0] stands for the first table in the hierarchy, since Telerik RadGrid supports multiple tables at a level

End If

End Sub

Here is the structure and code:
MainGrid
    MaterTableView
        DetailTable
            NestedViewTemplate (using nested view because each detail table row will have different datasource)
                ChildGrid

<telerik:GridTableView DataKeyNames="EmployeeNo, CategoryId" Name="Category" Width="1050px" runat="server" PagerStyle-Position="bottom">

<telerik:RadGrid ID="EmpData" OnNeedDataSource="gridEmpData_NeedDataSource" runat="server" Width="1050px">

</ClientSettings>

</telerik:RadGrid>

</NestedViewTemplate>

<telerik:GridRelationFields DetailKeyField="EmployeeNo" MasterKeyField="EmployeeNo" />

</ParentTableRelation>

<telerik:GridBoundColumn DataField="EmployeeNo" UniqueName="EmployeeNo" Visible="false" />

<telerik:GridBoundColumn DataField="CategoryId" UniqueName="CategoryId" Visible="false" />

<telerik:GridBoundColumn HeaderText="" DataField="CategoryName" SortExpression="CategoryName" UniqueName="CategoryName" />

</Columns>

</telerik:GridTableView>

</DetailTables>

<telerik:GridTemplateColumn UniqueName="btnEdit" HeaderStyle-Width="30px" ItemStyle-Width="30px">

<asp:ImageButton ImageAlign=AbsBottom id="btnEditEmp" runat="server" imageurl="~/images/edit.gif" alternatetext="Edit" /> 

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn HeaderText="EmpNo" DataField="EmployeeNo" SortExpression="EmployeeNo" UniqueName="EmployeeNo" />

<telerik:GridBoundColumn HeaderText="Last Name" DataField="LastName" SortExpression="LastName" UniqueName="LastName" />

<telerik:GridBoundColumn HeaderText="First Name" DataField="FirstName" SortExpression="FirstName" UniqueName="FirstName" />

</MasterTableView>

Thanks!

11 Answers, 1 is accepted

answered on 07 Sep 2009, 07:25 AM

Hi,

Try setting the IgnorePaging property in the ExportSettings of the Grid to true along with the HierarchyDefaultExpanded property and see whether the details tables are also getting exported along with the master table.

VB:

    
                Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) 
        
                    RadGrid2.ExportSettings.ExportOnlyData = True 
        
                    RadGrid2.MasterTableView.HierarchyDefaultExpanded = True 
        
                    RadGrid2.ExportSettings.IgnorePaging = True 
        
                    RadGrid2.ExportSettings.OpenInNewWindow = True 
        
                    RadGrid2.MasterTableView.ExportToExcel() 
        
                End Sub

Shinu

answered on 07 Sep 2009, 02:24 PM

I tried with setting IgnorePaging property but only the first level is expanded in the excel sheet i.e. only the first detail table is expanded and other grid under the NestedViewTemplate does not appear on the export. I need to expand both the detail table when I export to excel. That is the reason I was trying to loop through all levels to expand using the recursive function - LoopHierarchyRecursive(grdEmpData.MasterTableView) provided in one of the demo pages but that does not help.

MainGrid
MaterTableView
DetailTable (1st level table)
NestedViewTemplate (using nested view because each detail table row above will have different datasource)
ChildGrid (2nd level table)

- Thanks!

answered on 08 Sep 2009, 08:35 AM

Hi Murad,

Please examine the code snippet bellow and let me know if it works for you.
VB.NET:

    
            Protected Sub Button1_Click(sender As Object, e As EventArgs)  
        
                ConfigureExport()  
        
                RadGrid1.MasterTableView.HierarchyDefaultExpanded = True 
        
                RadGrid1.Rebind()  
        
                RadGrid1.MasterTableView.ExportToExcel()  
        
            End Sub 
        
            Public Sub ConfigureExport()  
        
                RadGrid1.ExportSettings.ExportOnlyData = True 
        
                RadGrid1.ExportSettings.IgnorePaging = True 
        
                RadGrid1.ExportSettings.OpenInNewWindow = True 
        
            End Sub

I hope this helps.

Kind regards,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

answered on 08 Sep 2009, 10:30 PM

The only line difference from my code is the ReBind() method. I did not call this. However, this does not help exporting all 3 levels of detail tables. We have been posting back and forth with 4 statements (HierarchyDefaultExpanded, ExportOnlyData, IgnorePaging, OpenInNewWindow) but that does not expand all levels. Any other work around? The below code snippet from the demo does not help.

LoopHierarchyRecursive(grdEmpData.MasterTableView)

Sub LoopHierarchyRecursive(ByVal gridTableView As GridTableView)

For Each nestedViewItem As GridNestedViewItem In gridTableView.GetItems(GridItemType.NestedView) nestedViewItem.Expanded = True

If nestedViewItem.NestedTableViews.Length > 0 Then

LoopHierarchyRecursive(nestedViewItem.NestedTableViews(0))

End If

End Sub

answered on 19 Oct 2009, 03:25 PM

I am also having the same issue. I am trying to export a hierarchical grid with 3 levels. First level is Systems. Second level is System Assessments and Faciltiies under that System, and third level is Facility Assessments. The export is working correctly on the 1st and 2nd level but it is not exporting the 3rd level, the Facility Assessments.

Here is the code I am using to produce this:

            case "Export to Excel (Hierarchical)":
                RadGrid1.ExportSettings.ExportOnlyData = true;
                RadGrid1.ExportSettings.IgnorePaging = true;
                RadGrid1.ExportSettings.OpenInNewWindow = true;
                RadGrid1.MasterTableView.HierarchyDefaultExpanded = true;
                RadGrid1.MasterTableView.ExportToExcel();
                break;

Any help on how to export this third level with hierarchy intact is much appreciated.
Thanks
Kris

answered on 19 Oct 2009, 04:00 PM

export-three-level-hierarchy.zip

Hello Kris,

Attached to this message is a simple working project which handles the desired functionality. Please give it a try and let me know if it works for you.

I hope this helps.

Best wishes,
Pavlina
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

answered on 21 Aug 2010, 01:50 PM

Hiii,
I am facing problem in exporting nested template in to pdf. Every time ,it gives me a default pdf export ( without the data in nested template). For the same structure, I am able to export nested view in excel suucssfully.
I am surprised with this behaviour as line of codes for both export are lmost name

here is the code snippet, I am using

For export to Excel: ( This works fine and export nested Data also)
RadGrid1.ExportSettings.ExportOnlyData =true;

RadGrid1.ExportSettings.IgnorePaging =

true;

RadGrid1.ExportSettings.OpenInNewWindow =

true;

RadGrid1.ExportSettings.HideStructureColumns =

true;

RadGrid1.MasterTableView.HierarchyDefaultExpanded =

true;

RadGrid1.Rebind();

RadGrid1.MasterTableView.ExportToExcel();

For export to PDF:( this only gives up default Data)

RadGrid1.ExportSettings.ExportOnlyData =

true;

RadGrid1.ExportSettings.Pdf.PageWidth =

Unit.Pixel(900);

RadGrid1.ExportSettings.Pdf.PageHeight =

Unit.Pixel(612);

RadGrid1.ExportSettings.IgnorePaging =

true;

RadGrid1.ExportSettings.OpenInNewWindow =

true;

RadGrid1.ExportSettings.Pdf.PageTitle = TitleDoc;

RadGrid1.MasterTableView.HierarchyDefaultExpanded =

true;

RadGrid1.Rebind();

RadGrid1.MasterTableView.ExportToPdf();

One thing, I noticed there is nochange in behviour even if I remove
RadGrid1.Rebind() line.

In nested template we are using a list view and binding its columns.

NestedViewTemplate>

<asp:Panel ID="panel1" runat="server" BorderStyle="Solid" BorderWidth="2px">

<telerik:RadListView ID="RadListView1" runat="server" DataSourceID="ObjectDataSource1"

ItemPlaceholderID="ParentContainer">

<legend>Terminal Details</legend>

<asp:PlaceHolder ID="ParentContainer" runat="server" />

</fieldset>

</LayoutTemplate>

<tr>

<asp:Label ID="Label1" runat="server" Text="SITE ID:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label2" runat="server" Text="SITE NAME:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label3" runat="server" Text="ADDRESS:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label4" runat="server" Text="CITY:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label5" runat="server" Text="STATE:" Font-Bold="true"></asp:Label>

</td>

</tr>

-- This row is for values of a label --%>

# Eval("SITE_ID")%>

</td>

# Eval("SITE_NAME")%>

</td>

# Eval("ADDRESS")%>

</td>

# Eval("CITY")%>

</td>

# Eval("STATE")%>

</td>

</tr>

</table>

</td>

</tr>

<tr>

<asp:Label ID="Label6" runat="server" Text="PARENT ID:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label7" runat="server" Text="SERIAL 1:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label8" runat="server" Text="SERIAL 2:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label9" runat="server" Text="LUNO:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label10" runat="server" Text="MODE NAME" Font-Bold="true"></asp:Label>

</td>

</tr>

# Eval("PARENT_ID")%>

</td>

#Eval("SERIAL1")%>

</td>

# Eval("SERIAL2")%>

</td>

# Eval("LUNO")%>

</td>

# Eval("MODE_NAME")%>

</td>

</tr>

</table>

</td>

</tr>

<tr>

<asp:Label ID="Label12" runat="server" Text="MODEL NAME:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label13" runat="server" Text="MANUFACTURER NAME:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label14" runat="server" Text="TYPE NAME:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label15" runat="server" Text="PHONE1:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label11" runat="server" Text="PHONE2:" Font-Bold="true"></asp:Label>

</td>

</tr>

# Eval("MODEL_NAME")%>

</td>

# Eval("MANUFACTURER_NAME")%>

</td>

# Eval("TYPE_NAME")%>

</td>

# Eval("PHONE1")%>

</td>

# Eval("PHONE2")%>

</td>

</tr>

</table>

</td>

</tr>

<tr>

<asp:Label ID="Label16" runat="server" Text="PHONE3:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label17" runat="server" Text="PHONE4:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label18" runat="server" Text="COMM DATE 1:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label19" runat="server" Text="COMM DATE 2:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label20" runat="server" Text="TRANS DATE LAST:" Font-Bold="true"></asp:Label>

</td>

</tr>

# Eval("PHONE3")%>

</td>

# Eval("PHONE4")%>

</td>

# Eval("COMM_DATE_1")%>

</td>

# Eval("COMM_DATE_2")%>

</td>

# Eval("TRANS_DATE_LAST")%>

</td>

</tr>

</table>

</td>

</tr>

<tr>

<asp:Label ID="Label21" runat="server" Text="SURCHARGE:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label23" runat="server" Text="BIN EXEMPT:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label24" runat="server" Text="xyz1:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label25" runat="server" Text="xyz2:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label22" runat="server" Text="xyz3:" Font-Bold="true"></asp:Label>

</td>

</tr>

# Eval("SURCHARGE")%>

</td>

# Eval("BIN_EXEMPT")%>

</td>

# Eval("xyz1")%>

</td>

# Eval("xyz2")%>

</td>

# Eval("xyz3")%>

</td>

</tr>

</table>

</td>

</tr>

<tr>

<asp:Label ID="Label26" runat="server" Text="AID ACCESS CUST:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label27" runat="server" Text="AID CONTRACT FL:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label28" runat="server" Text="AID CONTRACT SL:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label29" runat="server" Text="AID CONTRACT CASH:" Font-Bold="true"></asp:Label>

</td>

<asp:Label ID="Label30" runat="server" Text="PARENT NAME:" Font-Bold="true"></asp:Label>

</td>

</tr>

# Eval("AID_ACCESS_CUST")%>

</td>

# Eval("AID_CONTRACT_FL")%>

</td>

# Eval("AID_CONTRACT_SL")%>

</td>

# Eval("AID_CONTRACT_CASH")%>

</td>

# Eval("PARENT_NAME")%>

</td>

</tr>

</table>

</td>

</tr>

</table>

</ItemTemplate>

</telerik:RadListView>

</asp:Panel>

</NestedViewTemplate>

please suggest me ..what different settings are required for PDF...

answered on 24 Aug 2010, 03:07 PM

export-nestedviewtemplate.zip

Hi Atul,

I tried setting up an export the way you were instructed to and it worked on my side. You can find a sample project attached demonstrating this approach working for a RadGrid with a RadListView in its NestedViewTemplate.

Additionally, you can check if the issue persists when you remove from the RadListView control's ItemTemplate and LayoutTemplate - all tags which are not server controls?

I hope this helps.

Best wishes,
Pavlina
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items