Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » Platform - User Assistance (UA) » Birt Nested Tables/Groups(How to build nested tables/grouping using a single XML data source)
Birt Nested Tables/Groups [message #663788] Wed, 06 April 2011 14:00 Go to next message
TerryWyatt01 is currently offline TerryWyatt01Friend
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

Re: Birt Nested Tables/Groups [message #664237 is a reply to message #663788] Thu, 07 April 2011 23:31 Go to previous message
Chris Goldthorpe is currently offline Chris GoldthorpeFriend
Messages: 815
Registered: July 2009
Senior Member
I think you posted this in the wrong forum - there is a BIRT forum which would work better.
Previous Topic:Suppressing Contents topics for main books
Next Topic:Providing Help in Preferences
Goto Forum:
  


Current Time: Sat Nov 29 02:48:53 GMT 2014

Powered by FUDForum. Page generated in 0.01682 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software