Jump to content
Changes to the Jaspersoft community edition download ×

How to combine data from multiple sources in one report?


baseballstorm50

Recommended Posts

Hi, I am using the community edition of iReport and JasperReports Server 5.0.0 to try and make reports that compare/contrast data from multiple sources. For example, I might want to use statistics from two separate Excel files in a chart in one report, or maybe I would take some data from an Excel file and also some data from a database and display that information in one report. 

 

In iReport, at the top of the screen, it seems like you must select only one data source for a given report (for example, FoodMart): 

DataSource1.PNG.1a64018337cf91f687fdae3f92fbfec0.PNG

 


Additionally, it also seems like you can only connect one data source to a report in Jasper Server:

DataSource2.PNG.d78d411037367b2237e85714907d598e.PNG

However on Jaspersoft's main site, in the "Reporting" section under "Products," it says that  "Jaspersoft reporting software takes information from one or more data sources and presents it in an easy-to-read, highly interactive format so business users can stay informed and make better." Could anyone provide some insight into this issue? Where can I find more information about how to do this? Is it only possible to use multiple data sources with the commercial version?

 

Thanks!

Link to comment
Share on other sites

  • Replies 5
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Posted Images

Hi,

If you create a report with multiple datasources then it means multiple queries in one report, Some component takes data from one query and some from another e.g.  table1 query 1 (Datasource) and table 2 takes from query 2(DS). Becouse one report takes one connection at a time.

So whats your requirement is one report having oracle and sql server as multiple datasource ? From my understanding i explain the above multiple datasource concept.

May be i am wrong. So let me know if you deploy your required solution.

 

Link to comment
Share on other sites

  • 4 years later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...