Jump to content
Changes to the Jaspersoft community edition download ×

reference xml data


Recommended Posts

By: slowfinger - slowfinger

reference xml data

2006-03-18 15:34

Hi all,

 

My report data are xml data so I used JRXmlData.

 

The data structure is as follows:

 

<Problemwurzel>

<StandardberichtProblemVO>

<Problem>

<Problemnummer></Problemnummer>

</Problem>

<Bearbeitungsschritte>

<StandardberichtBSMassnahmeVO>

<VorgBearbTs> 2006-03-14 15:09:50.171686 </VorgBearbTs>

<Bearbeitungsart>

</Bearbeitungsart>

</StandardberichtBSMassnahmeVO>

<StandardberichtBSAnalyseVO>

<Bemerkung>

<Text> some text</Text>

</Bemerkung>

<BearbeitungTs> 2006-03-14 15:09:50.171686 </BearbeitungTs>

<Bearbeitungsart>

</Bearbeitungsart>

</StandardberichtBSAnalyseVO>

</Bearbeitungsschritte>

</StandardberichtProblemVO>

</Problemwurzel>

 

The root XML Path is:

 

/Problemwurzel/StandardberichtProblemVO

 

I want to reference some of "StandardberichtProblemVO" elements and than all "StandardberichtBSMassnahmeVO" elements per "StandardberichtBSAnalyseVO" which is referenced by the relation of StandardberichtBSMassnahmeVO/VorgBearbTs->StandardberichtBSAnalyseVO/BearbeitungTs

How I can do that. I tried a lot but nothing works. So I tried:

 

Masterreport with :

/Problemwurzel/StandardberichtProblemVO

 

and subreport data source expression:

 

dataSource("/Problemwurzel/StandardberichtProblemVO/Bearbeitungsschritte/StandardberichtBSMassnahmeVO")

 

and in that subreport with

 

dataSource("/Problemwurzel/StandardberichtProblemVO/Bearbeitungsschritte/StandardberichtBSAnalyseVO[bearbeitungTs=" + $FmassnahmeVorgBearbTs + &quot]") to output the analyse bemerkung.

 

Who can help I really frustrated to realize this.

 

Thanks in forward

Rico

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...