How to Build TREE style REPORT
Hi all
in my database i have a table with following structure :
Pkey
Parent
Description ......
1
0
Item1
2
0
Item2
3
2
Item3
4
2
Item4
5
1
Item5
6
3
Item6
7
1
Item7
.
..
...
As you can see the above structure represent a TREE style like the following :
ROOT_ITEM
Item1
Item5
Item7
Item2
Item3
Item6
Item4
BUT notice that the number of records in this table and number of Levels of this tree are Un-Limited
So i want to know how can i create a report that makes an out-put like above TREE.
Thanks in advance.
Regards.
in my database i have a table with following structure :
Pkey
Parent
Description ......
1
0
Item1
2
0
Item2
3
2
Item3
4
2
Item4
5
1
Item5
6
3
Item6
7
1
Item7
.
..
...
As you can see the above structure represent a TREE style like the following :
ROOT_ITEM
Item1
Item5
Item7
Item2
Item3
Item6
Item4
BUT notice that the number of records in this table and number of Levels of this tree are Un-Limited
So i want to know how can i create a report that makes an out-put like above TREE.
Thanks in advance.
Regards.