Combine sql and Xpath datasources in one report

[dretwk]

I have a report with SQL main data source, I'm need to pass data from SQL to another data source Xpath, can I create table in report with main SQL data source and inside this report table with Xpath data source?

[dretwk]

I found a solution, create subreport with xml data source in masterSubreport, use connectionType "Use a data source Expression" and apply data source expression like this:

new net.sf.jasperreports.engine.data.JRXmlDataSource("/path_to_xml_file/file.xml").dataSource("/root/field[@id="+$F{FIELD}+"]")[/code]