Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 Aksu
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 Williams
Messages: 1595
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

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
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 Aksu
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 Williams
Messages: 1595
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

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Previous Topic:Data type characteristics
Next Topic:Problem with LDAP data
Goto Forum:
  


Current Time: Tue Sep 23 06:38:24 GMT 2014

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

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