wood burning stoves 2.0*
The moose likes Other Open Source Projects and the fly likes Jasper Report : Connecting multiple sources Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Jasper Report : Connecting multiple sources" Watch "Jasper Report : Connecting multiple sources" New topic
Author

Jasper Report : Connecting multiple sources

Yati Tan
Ranch Hand

Joined: May 28, 2005
Posts: 56
Hi,

Can we connect multiple sources at one time from jasper Report ? Do we have to drag drop columns or write querries using DBlinks ? Please let me know.

Thanks,
Yati


SCJP 1.4<br />SCJA 1.0<br />SCWCD 1.4
bilal sidiqui
Author
Greenhorn

Joined: Aug 09, 2010
Posts: 17
Hello Yati,

If multiple sources mean multiple tables of the same database, then you can do this just by writing the correct SQL query.

If you want to connect multiple databases, you need to use a subreport component for each new database. Please see the following recipe from my book, which demonstrates how to use different subreports (each connected to its own database) in a master report.

Using Multiple Relational Databases to Generate a Report.

Please also note that my JasperReports book demonstrates the use of variety of datasources including relational databases, XML files, and JavaBeans.


Bilal Siddiqui, Author of JasperReports 3.6.0 Development Cookbook
 
wood burning stoves
 
subject: Jasper Report : Connecting multiple sources
 
Similar Threads
unicode font support for pdf
Possible to pass multiple queries in JasperReports?
report generation in java swing
Limitatiions of Jasper Reports
Jasper reports image expresssion