[Solved] Hierarchy Grid - Sorting & Paging

[Nick]

I have a "Main" grid on the page which generates many reports based upon the user selection. 

Here is the code of the Grid:

<telerik:RadGrid ID="gvMainControl" runat="server" AutoGenerateColumns="true" GridLines="None"
    CellPadding="0" CellSpacing="0" AllowPaging="False" Skin="WebBlue" AllowSorting="true"
    ShowFooter="True" EnableLinqExpressions="false" AllowCustomPaging="false" >
    <MasterTableView TableLayout="Auto" AllowFilteringByColumn="False" PageSize="20"
        CommandItemDisplay="Top" AllowCustomPaging="false" >
    </MasterTableView>
</telerik:RadGrid>

Some of the reports requires Hierarchy Grids within the MasterTableView which we create once the user clicks the "Generate Report Button". Here is the code to add the DetailsTables on Button Click:        

    For i = 0 To intLevels

        Dim tableViewOrders As New Telerik.Web.UI.GridTableView()

        tableViewOrders.DataMember = dicTemp(i).GroupBy.GroupBy(0)

        gvMainControl.MasterTableView.DetailTables.Add(tableViewOrders)

    Next i

We use the NeedDataSource event to re-populate the main grid when needed:

Protected Sub gvMainControl_NeedDataSource(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles gvMainControl.NeedDataSource
        gvMainControl.DataSource = reporting_service.Run(Of Reporting.Item_DrillDown)()
        gvMainControl.MasterTableView.DataKeyNames = {"Category_Name"}
        gvMainControl.MasterTableView.ClientDataKeyNames = {"Category_Name"}
End Sub

Expending the grids works well and the data is shown via DetailsTableDataBind:      

Protected Sub gvMainControl_DetailTableDataBind(sender As Object, e As Telerik.Web.UI.GridDetailTableDataBindEventArgs) Handles gvMainControl.DetailTableDataBind

    If e.DetailTableView.DataMember = "Item_Name" Then
        Dim strCategory_Name As String = CType(e.DetailTableView.ParentItem, Telerik.Web.UI.GridDataItem).GetDataKeyValue("Category_Name")
        e.DetailTableView.DataSource = New Reporting_Service.Query(Global.Reporting_Service.Query.Report_Type.Items, New Dictionary(Of String, String) From {{"Category_Name", strCategory_Name}}, _
                                                                        Nothing, New Reporting_Service.Query.Group(New List(Of String)({"Item_Name"}), New List(Of String)({"Quantity", "Total_Price"})), New List(Of String)({"Quantity"}), True, Nothing, Me.strUniqueID).Run(Of Reporting.Item_DrillDown)()



    End If

Problem starts when you try to Sort or Page in the inner Grids. It simply doesn't work. No event gets fired, not "NeedDataSource" or "DetailsTableDataBind". 

Your help is appreciated. 

[Shinu]

Hi,

Please make sure that you have attached the events.
aspx:

<telerik:RadGrid ID="RadGrid1" runat="server"  OnDetailTableDataBind="RadGrid1_DetailTableDataBind" OnNeedDataSource="RadGrid1_NeedDataSource" ></telerik:RadGrid>

Thanks,
Shinu

[Nick]

Shinu,

Needdatasource do fire when sorting the main table and when opening inner tables.

DetailsDataBind fires when opening inner tables. Both events do not fire when sorting / paging inner tables.

Nick

[Kostadin]

Hello Nick,

I am afraid that you could not change the grid structure on button click event. You must ensure that the entire grid, including its detailed tables and columns, are modified on Page_Init so that the control ViewState remains consistent. I suggest you to check out the following help article which elaborates more on this matter.

All the best,
Kostadin
the Telerik team