I am having the problem in generating the 4th level hierarhy in the rad grid, I am dynamically generating the tables and biding it to the grid at the server side. Below is my code.
<telerik:RadGrid ID="RadGrid1" Skin="Office2007" runat="server" Width="95%" AutoGenerateColumns="False"
PageSize="7" AllowSorting="True" AllowPaging="True" GridLines="None" ShowStatusBar="true" AllowMultiRowSelection="true" >
<PagerStyle Mode="NumericPages"></PagerStyle>
<MasterTableView AllowMultiColumnSorting="True" DataKeyNames="dt1Id,Type" Width="100%" EnableNoRecordsTemplate="false" HierarchyLoadMode="serverBind" >
<Columns>
<telerik:GridBoundColumn SortExpression="dt1Id" HeaderText="DTID" HeaderButtonType="TextButton"
DataField="dt1Id" Resizable="True" Reorderable="True" Display="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Type" HeaderText="Type" HeaderButtonType="TextButton"
DataField="Type" Resizable="True" Reorderable="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Date" HeaderText="Date" HeaderButtonType="TextButton"
DataField="Date" Resizable="True" Reorderable="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="Description" HeaderText="Description" HeaderButtonType="TextButton"
DataField="Description" Resizable="True" Reorderable="True">
</telerik:GridBoundColumn>
</Columns>
<DetailTables >
<telerik:GridTableView Caption="" AllowSorting="false" DataKeyNames="dt1Id,dt2Id" Width="100%" ShowHeader="false" EnableNoRecordsTemplate="false" HierarchyLoadMode="serverBind">
<ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="dt1Id" MasterKeyField="dt1Id" />
</ParentTableRelation>
<Columns>
<telerik:GridBoundColumn HeaderText="dt2Id" HeaderButtonType="TextButton"
DataField="dt2Id" Display="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn HeaderText="Type" HeaderButtonType="TextButton"
DataField="Type">
<ItemStyle Width="207px" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn HeaderText="Date" HeaderButtonType="TextButton"
DataField="Date">
<ItemStyle Width="67px" />
</telerik:GridBoundColumn>
<telerik:GridTemplateColumn HeaderText="">
<ItemTemplate>
<asp:ImageButton id="imgbtn" imageurl="~/Images/btn_Edit.gif" runat="server" visible= <%# DataBinder.Eval(Container.DataItem, "Status")%>>
</asp:ImageButton>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn HeaderText="Description" HeaderButtonType="TextButton"
DataField="Description">
</telerik:GridBoundColumn>
</Columns>
<DetailTables>
<telerik:GridTableView Caption="" AllowSorting="false" DataKeyNames="dt2Id,dt3Id" Width="100%" ShowHeader="false" EnableNoRecordsTemplate="false" >
<ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="dt2Id" MasterKeyField="dt2Id" />
</ParentTableRelation>
<Columns>
<telerik:GridBoundColumn HeaderText="dt2Id" HeaderButtonType="TextButton"
DataField="dt2Id" Display="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn HeaderText="Type" HeaderButtonType="TextButton"
DataField="Type">
<ItemStyle Width="207px" />
</telerik:GridBoundColumn>
<telerik:GridBoundColumn HeaderText="Date" HeaderButtonType="TextButton"
DataField="Date">
<ItemStyle Width="67px" />
</telerik:GridBoundColumn>
<telerik:GridTemplateColumn HeaderText="">
<ItemTemplate>
<asp:ImageButton id="imgbtn" imageurl="~/Images/btn_Edit.gif" runat="server" visible= <%# DataBinder.Eval(Container.DataItem, "Status")%>>
</asp:ImageButton>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn HeaderText="Description" HeaderButtonType="TextButton"
DataField="Description">
</telerik:GridBoundColumn>
</Columns>
<DetailTables>
<telerik:GridTableView Caption="" AllowSorting="false" DataKeyNames="dt3Id,Ins#" Width="100%" ShowHeader="false" EnableNoRecordsTemplate="false" >
<ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="dt3Id" MasterKeyField="dt3Id" />
</ParentTableRelation>
<Columns>
<telerik:GridBoundColumn HeaderText="dt3Id" HeaderButtonType="TextButton"
DataField="dt3Id" Display="false">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn HeaderText="Ins#" HeaderButtonType="TextButton"
DataField="Ins#" Display="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn HeaderText="P/A" HeaderButtonType="TextButton"
DataField="P/A" Display="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn HeaderText="Date" HeaderButtonType="TextButton"
DataField="Date" Display="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn HeaderText="Batch#" HeaderButtonType="TextButton"
DataField="Batch#" Display="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn HeaderText="Type" HeaderButtonType="TextButton"
DataField="Type" Display="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn HeaderText="EDI File Name" HeaderButtonType="TextButton"
DataField="EDIFileName" Display="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn HeaderText="Status" HeaderButtonType="TextButton"
DataField="Status" Display="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn HeaderText="HBOC File" HeaderButtonType="TextButton"
DataField="HBOCFile" Display="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn HeaderText="Rec.Date" HeaderButtonType="TextButton"
DataField="RecDate" Display="True">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn HeaderText="Rec.By" HeaderButtonType="TextButton"
DataField="RecBy" Display="True">
</telerik:GridBoundColumn>
</Columns>
</telerik:GridTableView>
</DetailTables>
</telerik:GridTableView>
</DetailTables>
</telerik:GridTableView>
</DetailTables>
</MasterTableView>
<ClientSettings>
<Selecting AllowRowSelect="true" />
</ClientSettings>
</telerik:RadGrid>
My code behind code
RadGrid1.DataSource = dtTable1
RadGrid1.MasterTableView.DataSource = dtTable1
RadGrid1.MasterTableView.DetailTables(0).DataSource = dtTable2
RadGrid1.MasterTableView.DetailTables(0).DetailTables(0).DataSource = dtTable3
RadGrid1.MasterTableView.DetailTables(0).DetailTables(0).DetailTables(0).DataSource = dtTable4
Table structure -dtTable1
dt1Id | Type | Date | EmptyColumn | Description |
1 | Patient Encounters | 2 Cases. First DOS: 08/11/2006 , Last DOS: 10/31/2006 | ||
2 | Patient Statements | 9 Statements, Last Statement: Monthly Statement on 01/02/2008 - Statement Balance: 308 | ||
3 | Patient Notes | 1 Notes, Last note on 12/12/2006 |
dt1Id | dt2Id | Type | Date | EmptyColumn | Description | Status |
1 | 2 | Case #: 38253 | 08/11/2006 | Batch #:ACF-081406-001 | TRUE | |
1 | 3 | Case #: 40081 | 10/31/2006 | Batch #:ACF-110106-001 | TRUE | |
2 | Daily Statement | 12/06/2006 | Statement Balance: 658 | FALSE | ||
2 | Monthly Statement | 01/03/2007 | Statement Balance: 658 | FALSE |
Table Structure - dtTable3
dt2Id | dt3Id | Type | Date | EmptyColumn | Description | Status |
2 | 0 | 08/15/2006 | Data Entry Date | FALSE | ||
2 | 0 | 08/15/2006 | Coding Date | FALSE | ||
2 | 3 | 08/15/2006 | Claim - Physician Claim Submitted for 658 for Primary Carrier: MUTUAL OF OMAHA (Carrier Code: 24585) | TRUE | ||
2 | 3 | 10/03/2006 | Claim - Physician Claim Submitted for 658 for Secondary Carrier: UNITED AMERICAN INS CO (Carrier Code: 11088) | TRUE | ||
3 | 0 | 11/01/2006 | Data Entry Date | FALSE | ||
3 | 0 | 11/02/2006 | Coding Date | FALSE | ||
3 | 4 | 11/07/2006 | Claim - Assistant Claim Submitted for 455 for Primary Carrier: MUTUAL OF OMAHA (Carrier Code: 24585) | TRUE | ||
3 | 4 | 11/30/2006 | Claim - Assistant Claim Submitted for 455 for Secondary Carrier: UNITED AMERICAN INS CO (Carrier Code: 11088) | TRUE |
Table Structure - dtTable4
dt2ID | dt3Id | Ins# | P/A | Date | Batch# |
2 | 3 | 48457 | P | 08/15/2006 | ACF-081506-004 |
2 | 3 | 48458 | P | 10/03/2006 | |
3 | 4 | 51376 | A | 11/07/2006 | ACF-110706-002 |
3 | 4 | 51377 | A | 11/30/2006 | ACF-113006-003 |
I am able to get upto 3 level hierachy's but iam not getting the 4th level. Kindly advise.
Regards,
Santhosh