Can we create tree table in birt to represent parent child relationship?

Can we create tree table in birt to represent parent child relationship using birt reporting. 
 
I need something similar to <a class='bbc_url' href='http://dev.sencha.com/deploy/ext-4.0.0/examples/tree/treegrid.html'>ExtJS Tree Grid</a> In my database table childs have a parent id.

Find more posts tagged with

Comments

mwilliams

What does your data look like? Is there a fixed number of levels, in the tree?

M.Nitesh

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="109222" data-time="1347462044" data-date="12 September 2012 - 08:00 AM">
What does your data look like? Is there a fixed number of levels, in the tree? </blockquote>
Thanks for the reply. 
No we do not have fixed number of levels. We have rows in same database table where child rows have its parent id as column.

mwilliams

If you had a fixed number of levels, you could probably have used grouping to do this, with BIRT's standard features. However, with no limit to the levels, I don't know that there's a simple way to do this. Here is a link to a thread that gives some ideas. Another idea might be that if you could compute the level of each element, in a computed column, you might be able to use spacing to get the look you're going for.

http://www.birt-exchange.org/org/forum/index.php/topic/15886-hierarchical-representation-tree-view-data/?=newpost&t=15886