Passing 2nd DB connection to report

[forthamilton]

Is there any way to pass 2nd DB connection to report? I have a report that need to fethc data from 2 database. I can build 2 separate JDBC datasources in JasperServer, but can't find a way to pass all of them to report.

[tmatyashovsky]

Hi,

 

Not sure if its possible but you can create main report and 2 sub reports in it.

For each of the sub reports you can pass different connection.

 

Hope that will help.

 

Best regards,

Taras Matyashovsky