Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
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 21:45 Go to next message
Levent Aksu is currently offline Levent AksuFriend
Messages: 2
Registered: December 2012
Junior Member
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 23:41 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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

Michael

Developer Evangelist, Silanis
icon14.gif  Re: master with two sibling details from an XML data source [message #990596 is a reply to message #990340] Thu, 13 December 2012 11:28 Go to previous messageGo to next message
Levent Aksu is currently offline Levent AksuFriend
Messages: 2
Registered: December 2012
Junior Member
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 05:38 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

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.

Michael

Developer Evangelist, Silanis
Previous Topic:Data type characteristics
Next Topic:Problem with LDAP data
Goto Forum:
  


Current Time: Fri Mar 29 05:32:53 GMT 2024

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

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

Back to the top