Eclipse Community Forums: BIRT » master with two sibling details from an XML data source

Home » Archived » BIRT » master with two sibling details from an XML data source

master with two sibling details from an XML data source [message #990330]

Tue, 11 December 2012 16:45

Eclipse User

Hi,
I am new to BIRT and cannot figure out how to cook a specific kind of report.
My data source is an XML file similar to the following:

<masters>
    <master id="1" name="A">
        <details>
            <detail id="100" desc="abc"/>
            <detail id="101" desc="def"/>
            <detail id="102" desc="ghi"/>
        </details>
        <otherdetails>
            <otherdetail id="1001" description="qwert"/>
            <otherdetail id="1002" description="asdfg"/>
        </otherdetails>
    </master>
    <master id="2" name="B">
        <details>
            <detail id="200" desc="jkl"/>
            <detail id="201" desc="mno"/>
        </details>
        <otherdetails>
            <otherdetail id="2001" description="wert"/>
            <otherdetail id="2002" description="sdfg"/>
            <otherdetail id="2003" description="xcvb"/>
            <otherdetail id="2004" description="xcvb"/>
        </otherdetails>
    </master>
</masters>

From that data source I need to draw a parallel report:

Masters
-------
1 A
    Details
    -------
    100 abc
    101 def
    102 ghi
    Other Details
    -------------
    1001 qwert
    1002 asdfg

2 B
    Details
    -------
    200 jkl
    201 mno
    Other Details
    -------------
    2001 wert
    2002 sdfg
    2003 xcvb
    2004 xcvb

That is two sibling "detail"s tied to one "master".
I tried to create 3 different data sets and connect them through data set parameters but I have not been able to define a filter based on a parameter in an XML dataset.
Possibly, my approach is not correct.
What would you suggest?
Thanks.

Re: master with two sibling details from an XML data source [message #990340 is a reply to message #990330]

Tue, 11 December 2012 18:41

Eclipse User

Take a look at this example. It uses two dataSets and a grouped table with a filtered sub-table.

Attachment: XMLSource.rptdesign
(Size: 25.16KB, Downloaded 349 times)

Re: master with two sibling details from an XML data source [message #990596 is a reply to message #990340]

Thu, 13 December 2012 06:28

Eclipse User

Hi Michael,
Thank you very much for the solution. It is also impressive to see someone who is fluent with BIRT can come up with an example report so quickly that it is even easier than trying to explain the concept on a message.
I have examined the example and it took me some time to figure out the connection between two data sets which was the table "filter". Later on I investigated how to add a third sibling detail and I just solved that too. So I got answers to all I can ask design-wise.
One question coming to my mind is if that filter runs efficiently with large detail datasets.
Thank you very much.
Levent

Re: master with two sibling details from an XML data source [message #990750 is a reply to message #990596]

Fri, 14 December 2012 00:38

Eclipse User

Sorry if I didn't explain enough! The filter might cause you some performance issues, with a lot of data. You might test it out and see if it's an issue. If it is, we might be able to come up with something else.

Previous Topic:	Data type characteristics
Next Topic:	Problem with LDAP data

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 03 16:13:54 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter