[Solved] HierarchyDefaultExpanded problem

[Philip]

So my grid works fine when I don't specify HierarchyDefaultExpanded, but when I add HierarchyDefaultExpanded="true" to my MasterTableView tab, I get the following error:

task_id is neither a DataColumn nor a DataRelation for table .

When I setup my hierarchy, I followed the example as closely as possible, and like I said, it works without this option enabled...but there are a couple scenarios where we want to use this feature. Here's my grid code if that helps:

<telerik:RadGrid ID="RadGrid1"
    Skin="Telerik"
    ImagesPath="images/grid/"
    AllowSorting="true"
    PageSize="25"
    ShowFooter="true"
    AllowPaging="false"
    ShowGroupPanel="true"
    GroupingEnabled="true"
    OnNeedDataSource="RadGrid1_NeedDataSource"
    OnItemDataBound="RadGrid1_ItemDataBound"
    Width="950"
    runat="server">
    <MasterTableView Name="master" CommandItemDisplay="None" DataKeyNames="request_id" Width="100%" HorizontalAlign="NotSet" AutoGenerateColumns="False" AllowSorting="true" GroupsDefaultExpanded="false" HierarchyLoadMode="ServerOnDemand" HierarchyDefaultExpanded="true">
        <Columns>
            <telerik:GridTemplateColumn HeaderText="Request #" DataField="request_id" UniqueName="request_id" SortExpression="request_id" Groupable="false">
                <ItemStyle Width="75" />
                <ItemTemplate>
                    <a href='request.aspx?id=<%# Eval("request_id") %>' style="cursor:pointer;"><asp:Label Width="65" CssClass="gridLabel" runat="server" ID="lbl_request_id" Text='<%# Eval("request_id") %>' /></a><br />
                    <asp:Label Width="70" CssClass="gridLabel" runat="server" ID="lbl_request_type" Text='<%# Eval("request_type") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridBoundColumn UniqueName="request_type" DataField="request_type" AllowFiltering="true" Visible="false" />
            <telerik:GridTemplateColumn HeaderText="Request Date" UniqueName="request_date" SortExpression="request_date" Groupable="false">
                <ItemStyle Width="90" />
                <ItemTemplate>
                    <asp:Label Width="85" CssClass="gridLabel" runat="server" ID="lbl_request_date" Text='<%# Eval("request_date") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Requestor" UniqueName="requestor_name" DataField="requestor_name" SortExpression="requestor_name" GroupByExpression="requestor_name Requestor Group By requestor_name">
                <ItemStyle Width="105" />
                <ItemTemplate>
                    <asp:Label Width="100" CssClass="gridLabel" runat="server" ID="lbl_requestor_name" Text='<%# Eval("requestor_name") %>' /><br />
                    <asp:Label Width="100" CssClass="gridLabel" runat="server" ID="lbl_requestor_dept" Text='<%# Eval("requestor_dept") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Purpose" UniqueName="title" SortExpression="title" Groupable="false">
                <ItemTemplate>
                    <asp:Label CssClass="gridLabel" runat="server" ID="lbl_title" Text='<%# Eval("title") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Due Date" UniqueName="due_date" SortExpression="due_date" GroupByExpression="due_date Due Group By due_date">
                <ItemStyle Width="85" />
                <ItemTemplate>
                    <asp:Label Width="80" CssClass="gridLabel" runat="server" ID="lbl_due_date" Text='<%# Eval("due_date") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Assigned To" UniqueName="analyst_name" DataField="analyst_name" SortExpression="analyst_name" GroupByExpression="analyst_name Assigned Group By analyst_name" AllowFiltering="true">
                <ItemStyle Width="105" />
                <ItemTemplate>
                    <asp:Label Width="100" CssClass="gridLabel" runat="server" ID="lbl_analyst_name" Text='<%# Eval("analyst_name") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Status" UniqueName="status" DataField="status" SortExpression="status" GroupByExpression="status Status Group By status">
                <ItemStyle Width="65" />
                <ItemTemplate>
                    <asp:Label Width="60" CssClass="gridLabel" runat="server" ID="lbl_status" Text='<%# Eval("status") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Priority" UniqueName="priority" SortExpression="priority" GroupByExpression="priority Priority Group By priority">
                <ItemStyle Width="60" />
                <ItemTemplate>
                    <asp:Label Width="55" CssClass="gridLabel" runat="server" ID="lbl_priority" Text='<%# Eval("priority") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
            <telerik:GridTemplateColumn HeaderText="Age" UniqueName="age" SortExpression="age" GroupByExpression="age Age Group By age">
                <ItemStyle Width="40" />
                <ItemTemplate>
                    <asp:Label Width="35" CssClass="gridLabel" runat="server" ID="lbl_age" Text='<%# Eval("age") %>' />
                </ItemTemplate>
            </telerik:GridTemplateColumn>
        </Columns>
        <DetailTables>
            <telerik:GridTableView Name="detail" DataKeyNames="task_id" DataSourceID="TaskDataSource" Width="100%" runat="server" CommandItemDisplay="None" AutoGenerateColumns="false">
                <ParentTableRelation>
                    <telerik:GridRelationFields DetailKeyField="request_id" MasterKeyField="request_id" />
                </ParentTableRelation>
                <Columns>
                    <telerik:GridTemplateColumn HeaderText="Task #" UniqueName="task_no" SortExpression="task_no" Groupable="false">
                        <ItemStyle Width="75" />
                        <ItemTemplate>
                            <asp:Label Width="70" CssClass="gridLabel" runat="server" ID="lbl_task_no" Text='<%# Eval("task_no") %>' />
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn HeaderText="Task Date" UniqueName="task_date" SortExpression="task_date" Groupable="false">
                        <ItemStyle Width="90" />
                        <ItemTemplate>
                            <asp:Label Width="85" CssClass="gridLabel" runat="server" ID="lbl_task_date" Text='<%# Eval("task_date") %>' />
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn HeaderText="Due Date" UniqueName="task_due_date" SortExpression="task_due_date" Groupable="false">
                        <ItemStyle Width="105" />
                        <ItemTemplate>
                            <asp:Label Width="100" CssClass="gridLabel" runat="server" ID="lbl_task_due_date" Text='<%# Eval("task_due_date") %>' />
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn HeaderText="Task" UniqueName="task_title" SortExpression="task_title" Groupable="false">
                        <ItemTemplate>
                            <asp:Label CssClass="gridLabel" runat="server" ID="lbl_task_title" Text='<%# Eval("task_title") %>' />
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn HeaderText="Complete Date" UniqueName="task_complete_date" SortExpression="task_complete_date" Groupable="false">
                        <ItemStyle Width="85" />
                        <ItemTemplate>
                            <asp:Label Width="80" CssClass="gridLabel" runat="server" ID="lbl_task_complete_date" Text='<%# Eval("task_complete_date") %>' />
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn HeaderText="Assigned To" UniqueName="task_analyst_name" SortExpression="task_analyst_name" Groupable="false">
                        <ItemStyle Width="105" />
                        <ItemTemplate>
                            <asp:Label Width="100" CssClass="gridLabel" runat="server" ID="lbl_task_analyst_name" Text='<%# Eval("task_analyst_name") %>' />
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn HeaderText="Status" UniqueName="task_status" SortExpression="task_status" Groupable="false">
                        <ItemStyle Width="65" />
                        <ItemTemplate>
                            <asp:Label Width="60" CssClass="gridLabel" runat="server" ID="lbl_task_status" Text='<%# Eval("task_status") %>' />
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn HeaderText="" UniqueName="blank" SortExpression="blank" Groupable="false">
                        <ItemStyle Width="60" />
                        <ItemTemplate>

                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridTemplateColumn HeaderText="Age" UniqueName="age" SortExpression="age" GroupByExpression="age Age Group By age">
                        <ItemStyle Width="40" />
                        <ItemTemplate>
                            <asp:Label Width="35" CssClass="gridLabel" runat="server" ID="lbl_age" Text='<%# Eval("age") %>' />
                        </ItemTemplate>
                    </telerik:GridTemplateColumn>
                </Columns>
            </telerik:GridTableView>
        </DetailTables>
    </MasterTableView>
    <ClientSettings AllowDragToGroup="True" AllowGroupExpandCollapse="True">
        <Selecting AllowRowSelect="True" />
        <Scrolling AllowScroll="false" UseStaticHeaders="True" />
        <ClientEvents OnGridCreated="GridCreated" />
    </ClientSettings>
    <PagerStyle Mode="NextPrevAndNumeric" />
</telerik:RadGrid>

Any help is greatly appreciated.

[Yavor]

Hello Philip,

Does this error occur when you do not include the HierarchyDefaultExpanded property, but try to manually expand the levels? Additionally, this looks like a problem in the way the control is constructed.
In order to further assist, it would be best if you open a formal support ticket, and send us the problematic sample, for additional investigation.

Regards,
Yavor
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Robert Cathey]

No...if I leave out the HierarchyDefaultExpanded option, the hierarchy expands fine. This was the intended use and then I got some feedback from the users indicating that on their personal queue, they would like all the items expanded on load.

I'll try to put together a small project...it's getting hard as this application gets larger :)

[Robert Cathey]

Sorry if this is confusing...I posted the original question under my personal account, but the reply under our company account since they purchased a license. The problem is occurring with a company project.

[Yavor]

Hi Robert,

In order to further assist you, it would be best if you open a formal support ticket, and send us a small working project, which we can debug locally, and track down the cause of the problem.

Kind regards,
Yavor
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Venkat]

I am having the same problem. Philip did you ever got this fixed.

Thanks!