to display data in tree structure

RiaR

Hi Williams,<br />
My table output should like a tree structure.The data's in the database will look like <br />
<br />
Id | name | Manager_id <br />
111 | Arun | 101<br />
121 | Ravi | 101 <br />
131 | Sita | 111 <br />
102 | Benny | 111<br />
101 | Mile |<br />
<br />
<strong class='bbc'>My output should be</strong><br />
<ul class='bbc'><li>Mile <br />
<ul class='bbc'><li> Arun <br />
</li><li>Sita</li><li>Benny</li></ul></li><li> Ravi</li></ul>

<br />
How can I display the data's in BIRT.<br />
Thanks in advance.

mwilliams

If the data doesn't come in, in order, you'll probably have to store your dataSet data into an array and then write script to create an html list string to be displayed in an html text box. It may take a bit of work.