Use EXCEL sheet and query Oracle table

[jkeri]

I have a request from a user that incorporates the use of an EXCEL sheet from which to pull/extract data from an oracle table.

I have two data adapters set, one for the EXCEL nd one for the ORacle table.

Looks like I will have to use a subreport to display the Oracle table and the main report will be the EXCEL.    Is this possible?

 

This is our first attempt at using an EXCEL file and an ORacle Table in the same report.

 

[reportdev]

First Read this https://community.jaspersoft.com/wiki/how-use-multiple-data-sources-jaspersoft-studio-or-jasperreports-server

and if not working then

I think this is possible. but it needs some java coding.

Main dataset would query Excel spreadsheet - this is normal

Subreport dataset would query Oracle - this is where it gets tricky

usually the same connection string is passed in to the subreport from the main report.

but here two different datasources should be used, so REPORT_DATA_SOURCE parameter for the subreport from main report should be set to Oracle. 

If you are using java to generate this report, then you can pass this REPORT_DATA_SOURCE (JRDataSource object) parameter into the main report and then pass it into the subreport