Home
Analytics
BIRT report displaying a hierarchy
zac
Hello,
I've created a BIRT report in RTC 3.0.1 that displays workitems and their links.
Now, I'd like to display a hierarchical view to show Parent workitems with their children workitems in a tree view (indentation) fashion. The view can be static.
What is the best way to do that in BIRT as I don't see any support for a tree view?
Thank you in advance for your help
Find more posts tagged with
Comments
mwilliams
Can you show a little bit of data, so I can see the relationship between parent/children? Thanks!
zac
This is what I've done in a nutshell. I've created a data set with table LIVE_WORKITEM_CNT and 2 others data sets for table LINKS; one that takes TARGET_ITEMID as an input to get the SOURCE_ITEMID and another one that takes SOURCE_ITEMID as an input to get the TARGET_ITEMID. I've added the LINKS data sets as a sub query in the LIVE_WORKITEM_CNT data set. The current row ID from LIVE_WORKITEM_CNT is used as a parameter to get the links. I can display the workitems with their links (target and source) but now I'd like to display the items in a hierarchical fashion as I only need to display parent/child links.
I was wondering how one would tackle this in BIRT. Should I store everything in a javascript map and render it in a dynamic text? Are there any samples?
Any advice is most than welcome.
Thanks,
mwilliams
If you can show me some sample data and give me your version, I'll try to make you an example. Otherwise, some suggestions could be to use grouping to display the two levels, if you have it all your data in a single dataSet. If the parents and children are in different dataSets, you could embed a table bound to the second dataSet into one bound to the first dataSet, and use filters or dataSet parameter binding to get the correct child data with the right parent.
durgendra
<p>i want like this in one report</p><p> customer number (on click )</p><p> than details of customers (order, products, addressetc)</p><p> </p><p> then click on details</p><p> view order details or product details</p><p> then so so ........</p>
mwilliams
<p>Can you be more specific? You want a list of customers? If you click a customer, expand that customer showing customer info, orders, etc. sections that can be expanded and clicked in for more detail? Let me know.</p>
durgendra
<p>actually i want the hyper links on the customer number, than customernumber:ordernumber, than on ordernumber:orderdetails...... so on in nested tables form</p><p>and thank you so much for replying</p>
mwilliams
<p>So, you'd have three reports, one that was a list of customernumbers with hyperlinks to a report that shows the customer's orders. Then, that report would have links on each order for the user to drill down into a report about the order details? Or is this all going to be in a single report? What is your BIRT version?</p>
durgendra
<p>ya exactly all these three in single report.</p><p>ver:- 3.7.0.v2......</p><p> </p><p>i already seen this : <span style="font-size:12px;">Sample drill down BIRT Reports</span></p><p> </p><p><a data-ipb='nomediaparse' href='
http://www.birt-exchange.org/devshare/_/designing-birt-reports/518-sample-drill-down-birt-reports'>http://www.birt-exchange.org/devshare/_/designing-birt-reports/518-sample-drill-down-birt-reports</a></p><p>but
in this 3 different reports are used.</p><p> </p><p><span style="font-size:18px;">one more question</span> <span style="font-size:12px;">Expandable/Collapsible Groups by Drill Through</span></p><p><a data-ipb='nomediaparse' href='
http://www.birt-exchange.org/devshare/_/designing-birt-reports/1242-expandablecollapsible-groups-by-drill-through'>http://www.birt-exchange.org/devshare/_/designing-birt-reports/1242-expandablecollapsible-groups-by-drill-through</a></p><p> </p><p>whenever
i try to open customer details through company name from 2 or 3 page of birt report viewer. my viewer puts me on the front or first page of the report. same problem i see in many reports....</p>
mwilliams
<p>The expandable/collapsible should be able to be modified to put you back on the page number you came from pretty easily. If that one is good enough for you, I can probably help you out with that. Or I can make you an example of how you can expand/collapse sections with client-side script. Let me know.</p>
durgendra
<p>thank you michael</p><p> can you figure out how i can do modify expandable/collapsible to put me back on the page number on that i click ( say 2 or 3 ) not on the 1st page.</p><p> </p><p>and also if you can make an example "expand/collapse sections with client-side script" for me. It will be more helpful for me to learn something new.</p>
mwilliams
<p>Here you go. This example should jump you to the last selected customer number, no matter what page it end up on after the expansion. This is done by using a bookmark on the group label and in the hyperlink set up on the group label, the customer selected is passed as the jump to value. Hope this helps.</p>
durgendra
<p>thank you..</p><p>it helped me a lot..</p><p>but whenever i try to increase levels of hyper-linking in tree.</p><p>like making another hyperlink on the check-number to see the check details from subtable2 ( which i drop in the subTable cell). than how it can be possible...</p><p> </p><p>i tried same way hyper linking on check details like on customer name. but it shows error like ..</p><p>the bookmark: ... is invalid. please check and reset the link.
show exception stack trace</p>
durgendra
<p>i need something like that...</p>
mwilliams
<p>The only thing you were missing was the bookmark on the orders table to be able to have the "jump to" feature. Take a look.</p>
durgendra
<p>thank you so much..</p><p>this is exactly what i needed..</p><p> </p><p>again thank you michael</p>
mwilliams
<p>You're welcome! Let us know whenever you have questions!
</p>
durgendra
<p>i need to repeat the repeatation of city</p><p>please help me sir</p><p> </p><p> </p><p> </p>
mwilliams
<p>I'm not sure if I'm understanding correctly or not. Can you please explain this further? Thanks!</p>
durgendra
<p>here one country Australia</p><p> three states (nsw, queensland, victoria)</p><p> nsw have 2 cities ( North sydney, chatswood)</p><p> </p><p>in dataset for first table query: select CLASSICMODELS.CUSTOMERS.COUNTRY
from CLASSICMODELS.CUSTOMERS
group by CLASSICMODELS.CUSTOMERS.COUNTRY</p><p> </p><p>but the i can't do this group by for states and the cities.</p><p> </p><p> </p><p>so the state (nsw repeats 2 times and it have 2 cities)</p><p> </p><p>but not the state: queensland</p><p>then again the state victoria (2 times repeat) 2 cities (melbourne, glen waverly)</p><p> </p><p>repeatation of states increases states increases as the number of cities increases like for france....</p><p> </p><p> </p><p>my problem is i need to remove this repeatation. states</p>
mwilliams
<p>Maybe this will help some. If the detail data is not unique on each row, you need to put the embedded table in the group header/footer. That will remove the duplicates. Hope this helps.</p>
durgendra
<p>thank you very much sir...</p>
mwilliams
<p>Not a problem. Let us know whenever you have questions!
</p>
kripa.s@tbitsglobal.com
<p>Hi Michel,</p><p> I have same report type and still facing same problem for more than one level hierarchy. Please help.</p>
