How to use multiple Data Sources in a Jasper Report?

Posted on April 25, 2015 at 8:16am

Hi Guys,

I need to create a Jasper report with 3 sub reports. 2 sub reports use data source say DS1 and the other sub report use data souce DS2. When I tried to preview the main report, it throws a sql error. Can anyone help me how to acheive this?

Thanks,

Andy

iReport Designer
JasperReports® Server
Jaspersoft® Studio
jo.jasmine's picture
jo.jasmine
267
Joined: Apr 6 2015 - 8:50am
Last seen: 4 years 7 months ago

2 Answers:

Posted on June 22, 2015 at 6:29pm

In creating a Jasper report, if the main report and its subreports use different data sources, you can only use Java classes or write an actual url, username and password, instead of referencing the data source names.

Yet, esProc is helpful in solving this type of multi-data-source problems. For details, refer to http://blog.raqsoft.com/?p=4243 .

calculate.machine's picture
calculate.machine
944
Joined: Jan 13 2015 - 11:40pm
Last seen: 7 years 6 months ago
Feedback