Convert SQL data and xml into one XML datasource

Hi!

I trying to code for Report using jasperReport.

I need to pass two different data source to the jasper report.

But jasperReport support only one datasource.

Both the datasource will be decided in runtime.

One of my datasource is SQL and other is XML these datasource has different Numbers of Row.(I don't know about XML as datasource much , I just know how to use it).

So if it possible to convert some how these data into an XML or any other datasource.(JasperReport support XML,connection and resultset)

If it is possible then how to do that.

Any example will be extreamly helpful.

I not a big time java programmer.

Thanks a lot for tour help in advance.

[728 byte] By [nitin403a] at [2007-11-27 11:38:13]