Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsBirt Nested Tables/Groups
https://www.eclipse.org/forums/index.php/mv/msg/207310/663788/#msg_663788
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.