Hi,
I am having a result set with the structure of
Level1 Level2 Level3 CalcField
---------------------------------------------------------------------------
Akron Cleveland OH 2007-QTR 1 206172.0000
Akron Cleveland OH 2007-QTR 2 225291.0000
Akron Cleveland OH 2007-QTR 3 210866.0000
Allen Dallas-Fort Worth TX 2009-QTR 1 27241.0000
Allen Dallas-Fort Worth TX 2009-QTR 2 62850.0000
Allen Dallas-Fort Worth TX 2009-QTR 3 100539.0000
And the output of the treelist should be,
Akron
Cleveland OH 642329.0000
2007-QTR 1 206172.0000
2007-QTR 2 225291.0000
2007-QTR 3 210866.0000
Allen
Dallas-Fort Worth 90091.0000
TX 2009-QTR 1 27241.0000
TX 2009-QTR 2 62850.0000
I have gone through the samples with ParentKeyname and DataKeyNames Concept.But i dont have the parentid concept in my query.
Can anyone help me..its urgent..
Any best way to achieve this?
I am having a result set with the structure of
Level1 Level2 Level3 CalcField
---------------------------------------------------------------------------
Akron Cleveland OH 2007-QTR 1 206172.0000
Akron Cleveland OH 2007-QTR 2 225291.0000
Akron Cleveland OH 2007-QTR 3 210866.0000
Allen Dallas-Fort Worth TX 2009-QTR 1 27241.0000
Allen Dallas-Fort Worth TX 2009-QTR 2 62850.0000
Allen Dallas-Fort Worth TX 2009-QTR 3 100539.0000
And the output of the treelist should be,
Akron
Cleveland OH 642329.0000
2007-QTR 1 206172.0000
2007-QTR 2 225291.0000
2007-QTR 3 210866.0000
Allen
Dallas-Fort Worth 90091.0000
TX 2009-QTR 1 27241.0000
TX 2009-QTR 2 62850.0000
I have gone through the samples with ParentKeyname and DataKeyNames Concept.But i dont have the parentid concept in my query.
Can anyone help me..its urgent..
Any best way to achieve this?