Eclipse Community Forums: Platform - User Assistance (UA)

Home » Eclipse Projects » Platform - User Assistance (UA) » Birt Nested Tables/Groups(How to build nested tables/grouping using a single XML data source)

Show: Today's Messages :: Show Polls :: Message Navigator

Birt Nested Tables/Groups [message #663788]

Wed, 06 April 2011 14:00

TerryWyatt01

Messages: 6
Registered: April 2011

Junior Member

I am pretty new to Birt and have been unable to find the solution to my problem yet.

I need nested tables that display a heirarchy like the following (see xml dataset at the bottom)
1) Table of Cases, each case containing
A) Table of CaseUsers, each case user containing
a) Table of Travel
B) Table of Actions, each Action containing
a) Table of Punishments

Is there an easy to maintain (hopefully drag and drop) way to read in a nested xml document (like the provided example) as a data source, and then map sub-portions of it as individual data sets? The goal is to implement grouping for each subset (Case, Action, CaseUser, Travel,
Punishment, etc.) to represent in nested tables.

I have been able to create the layout by adding the same data source several times, but this results in exponentially longer run times with each nested table, as Birt tries to retrieve the dataset for each and every xml tag (19 retrievals of the datasource for the provided xml sample).

The structure of this document will, in reality, be much more complex than the sample and currently (even at a more simple implementation) is unusable as the report runs for more than 30 minutes.

This type of XML representation is common, and it seems that this type of grouping should be easily available, but I am unable to get it to work properly. I have begun building scripted datasets, but that solution is not easily maintainable and I am hoping that I am just (currently) ignorant of a more elegant solution.

Any help would be appreciated.

<RowSet actionType="Action1">
<Case caseId="38930" dateClosed="10-Feb-2011" clientId="643412" clientName="Jake Foolish">
<Action actionCaseId="38930" dateServed="11-Nov-2010" adverseActionId="30" allegations="" actionTypeId="114" actionType="Action1">
<Punishment pAdverseActionId="30" pParagraph="Write I'm Sorry"/>
<Punishment pAdverseActionId="30" pParagraph="Another punishment"/>
<Punishment pAdverseActionId="30" pParagraph="50 Push-ups"/>
</Action>
</Case>
<Case caseId="80002" dateClosed="" clientId="99424" clientName="John Doe">
<CaseUser cuCaseId="80002" cuUserId="999242" cuDateAssigned="20-Oct-2010" cuDateRemoved="29-Oct-2010" cuNameFormatted="[Lawyer] Mrs. Hard Nose">
<Travel travelId="1234" location="Washington DC" purpose="Witness interview"/>
<Travel travelId="1372" location="Miami" purpose="Witness interview"/>
<Travel travelId="2366" location="Los Angeles" purpose="Consultation"/>
</CaseUser>
<CaseUser cuCaseId="80002" cuUserId="194263" cuDateAssigned="25-Oct-2010" cuDateRemoved="29-Oct-2010" cuNameFormatted="[Lawyer] Mr. Bleeding Heart">
</CaseUser>
<CaseUser cuCaseId="80002" cuUserId="224011" cuDateAssigned="01-Nov-2010" cuDateRemoved="01-Nov-2010" cuNameFormatted="[Paralegal] Goldie">
</CaseUser>
<Action actionCaseId="80002" dateServed="02-Nov-2010" adverseActionId="25" allegations="" actionTypeId="115" actionType="Action1">
<Punishment pAdverseActionId="25" pParagraph="Lots of Sit-ups."/>
<Punishment pAdverseActionId="25" pParagraph="30 lashes"/>
</Action>
<Action actionCaseId="80002" dateServed="01-Nov-2010" adverseActionId="26" allegations="" actionTypeId="114" actionType="Action1">
<Punishment pAdverseActionId="26" pParagraph="Imprisonment"/>
<Punishment pAdverseActionId="26" pParagraph="Solitary Confinement"/>
</Action>
</Case>
</RowSet>

[Updated on: Wed, 06 April 2011 14:39]

Report message to a moderator