Home » Archived » BIRT » Managing XML Datasource with subgroups.
| Managing XML Datasource with subgroups. [message #231776] |
Mon, 02 April 2007 11:10 |
Eclipse User |
|
|
|
Originally posted by: dpalomar.logic-factory.com
Hi All:
My question is about managing complex XML Datasources with serveral
subgroups of elements. I have found some questions about in the news but
without reply
( http://dev.eclipse.org/newslists/news.eclipse.birt/msg09930. html,
http://dev.eclipse.org/newslists/news.eclipse.birt/msg12613. html)
Question is general, about managing rich hierarchical XML, but, in order
to clarify, I’m using an example to avoid complex schemas references.
What I mean with subgroups are collections of elements like lines of
sales in an invoice. In real environments is normal to have several
levels of subgrouping in business documents. For example, a billing
order with several invoices , everyone containing a header (seller and
client information), a collection of sales lines (product, units,
discounts, etc.), a collection of taxes (tax, base, description, etc.),
a collection of transport costs, etc.
<billingOrder>
<!—Sequence of one or more invoice -->
<invoice>
<header>
<!—seller, client, date, total, etc. -->
</header>
<sales>
<!—Sequence of one or more saleLine -->
<saleLine>
<!—product, units, price, discount, etc. -->
</saleLine>
…
<taxes>
<!—Sequence of one or more taxLine -->
<taxLine>
<!—value, description, base, etc. -->
</taxLine>
…
</taxes>
</invoice>
…
</billingOrder>
In a first approximation I would define a DataSet for invoices with
Table Mapping in the /billingOrder/invoice element for data from the
header element, another one DataSet form sales with Table Mapping in
/billingOrder/invoice/sales/saleLine and the last one DataSet for Taxes
in /billingOrder/invoice/taxes/taxLine.
The three datasets would be linked in a report using linked subreports,
but I didn’t found a way to link XML Datasources. More about, in case it
would be possible, it would precise shared key to link master and
subordinated datasets. In XML this relation is supported by the
hierarchical nature of the document and there is no a shared fields like
used in relational structures.
Thanks in advance
|
|
|
Goto Forum:
Current Time: Sun Nov 09 14:07:40 EST 2025
Powered by FUDForum. Page generated in 0.03152 seconds |
Home