Jasper report that connects to multiple database

[rathishraghavan]

Hi,

I am working on a report system developement that generates reports from multiple database. For example, a report that display employee details where the Employee Name and Employee Id is available in DB1 and the employee department and designation would be in DB2. In need to display all four fields in one report. 

Would it be posible to generate such a report which points to multiple database for the same report? Would also need to know how this can be developed if possible. 

Eagerly awaiting for a reply

Thank You

Rathish MK Raghavan

[darth_fader]

It is possible, please view my post here:

http://community.jaspersoft.com/questions/540250/clarification-multiple-datasources-report

I've connected many datasources in the same report, but used a separate subreport for each datasource; combining data from those subreports would require return values to the parent report and manipulation there (or at least that's the approach I would take)