How to mix result of multiple different xpath values together?

[turifster]

Hi,

I use jasper report studio and I need the following table to be displayed from az XML file. (So the datasource is an xml)

Table columns:

A                  B                 C                   D             ....

xpath1       xpath3        xpath5        ....

xpath2      xpath4        xpath6       ....
 

For example. The column A rows come from items under xpath1 + values under xpath2

What I tried is to use subreports but It's hard to manage so many subreports.

I have to display around 15 columns and every column is a mix of different xpath values. For example xpath1 = contracts/contract/contractNum   xpath2 = devices/device/deviceNum

  Do you have best solution for handling these types of situation?

Thanks,

Ferenc