nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

BIRT - Hierarchical Tree Output

dbmathis

Hi All, 
 
I have been working on a hierarchical report for over a week now (about 50 hours of work at least). I am trying to create a report with a hierarchical tree type structure / output. I have written a bunch of code within the report to get what i think may be the right data into a scripted data set (which I have done successfully), however I have failed to accomplish what I set out to do, which is to create the output in Figure 3 below. I feel like I may have reached the limits of what BIRT can do and I am now at a point where I need to decide if this project is a go or no go. 
 
I am hoping the someone can look over what I am trying to do and what I have already done and perhaps help me bring this to completion or if not possible, let me know it's not possible so that I can move on. I have spent over a day cleaning up my sample data / design file to post here. I even used the top posters of this forum for the example hierarchical structure sample data.

Basically I start out with name / hierarchy (manager) pair and from this build a scripted data set that has what level (which is dynamic - number of levels will fluctuate) in the hierarchy a person is in, if they have subordinates and then a comma separated list of the total members / subordinates that exist in their org / branch of the tree. All of this is working. I just can't figure out at this point how to get from Figure 1 below to Figure 3. I realize very clearly that I am not the best BIRT designer on the planet and hope that a BIRT **** out there will be able to help me. LOL 
 
Figure 1 - Scripted data set output: 
<img src='http://tmfamily.info/birt/current_scripted_data_set_structure.png' alt='Posted Image' class='bbc_img' /> 
 
Figure 2 - My current progress: 
<img src='http://tmfamily.info/birt/current_birt_output_pdf.png' alt='Posted Image' class='bbc_img' /> 
 
Figure 3 - What I need to accomplish: 
<img src='http://tmfamily.info/birt/needed_birt_output.png' alt='Posted Image' class='bbc_img' /> 
 
 
Attached is the sample data and the design file. I am hoping that if what I am trying to do is possible, someone can use the attached design file and create a working example for me. 
 
Thanks

Find more posts tagged with

Comments

kclark

Sorry for the late response, are you still having issues with this? It looks like between image two and image three you've almost got it working, are you just having trouble with the next set of indentations to make it look like image three?

dbmathis

I was never able to figure it out. Still looking for help. 
 
There are two things as outlined above that I am having trouble with. 
 
<ul class='bbcol decimal'><li>The output of what I currently have is not a true hierarchical tree structure. I am grouping by level in Figure 2. It needs to be a true tree structure like Figure 3.</li><li>I am not able to get an aggregate for each branch of the tree, as seen in Figure 3.</li></ul>
 
This is not easy or for the faint of heart.

. But I would be eternally grateful to whomever can show me how this is done.

dbmathis

. But I would be eternally grateful to whomever can show me how this is done.

kclark

I have a report that does what I think you're needing. It grabs the id number, name, and manager id in a for loop and checks if it has a parent or not. It then put's the data into an array and then outputs this is dynamic text again using for loops. Take a look and see if this is something that we could modify and get it working for your needs. You can email me so I can send you the report.

HÃ¹ng Lee

can you send report to email :vanhieutta@gmail.com? thank you