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:
Any help is greatly appreciated.
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.