jo.jasmine Posted April 25, 2015 Share Posted April 25, 2015 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 Link to comment Share on other sites More sharing options...
calculate.machine Posted June 23, 2015 Share Posted June 23, 2015 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 . Link to comment Share on other sites More sharing options...
Solution kkumlien Posted February 24, 2017 Solution Share Posted February 24, 2017 http://community.jaspersoft.com/wiki/how-use-multiple-data-sources-jaspersoft-studio-or-jasperreports-serverhttps://community.jaspersoft.com/wiki/multiple-datasources-ireport-lists-tables-and-subreports Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now