Dataset filtering in a List

[paulk]

Hi,

I have following XML file and I am trying to display a parent and it's related children in the jasper report.

<family>
    <parent parentName="John">
        <children>
            <child childName="John Junior 1"/>
            <child childName="John Junior 2"/>
        </children>
    </parent>
    <parent parentName="Mike">
        <children>
            <child childName="Mike Junior 1"/>
            <child childName="Mike Junior 2"/>
            <child childName="Mike Junior 3"/>
        </children>
    </parent>
</family>

 

I am trying to create a report to show below:

John
    John Junior 1
    John Junior 2

Mike
    Mike Junior 1
    Mike Junior 2
    Mike Junior 3
 

But it is showing as below:

John
    John Junior 1
    John Junior 2
    Mike Junior 1
    Mike Junior 2
    Mike Junior 3

Mike
    John Junior 1
    John Junior 2
    Mike Junior 1
    Mike Junior 2
    Mike Junior 3
 

Can someone help?

thanks

 

[hozawa]

Just create a report with a group "parentName".

[paulk]

Thank you for the suggestion.  I have already tried that and it still does not work.  I am trying to figure out how the dataset (XML) can have the <child>  node within the parent node.

Anyone have an example of JaspeReport Studio report file (with sample xml)?

thanks

 

 

[hozawa]

Here you go. I just used a list with subdataset with $P{REPORT_DATA_SOURCE}) to list children names
 

[paulk]

Thank you Hozawa,

it is working well.