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

Problem in generating 4th Level Hierachy Grid

1 Answer 42 Views
Grid
This is a migrated thread and some comments may be shown as answers.
santhosh
Top achievements
Rank 2
santhosh asked on 20 Feb 2009, 01:27 PM
Hi,

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
Table Structure - dtTable2

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

1 Answer, 1 is accepted

Sort by
0
Daniel
Telerik team
answered on 23 Feb 2009, 07:56 AM
Hello Santhosh,

I tried to reproduce the mentioned issue to no avail. Find my test project attached to this post. Please modify it to behave as in your scenario so we can reproduce the problem locally.

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Tags
Grid
Asked by
santhosh
Top achievements
Rank 2
Answers by
Daniel
Telerik team
Share this question
or