Getting a data from 2 different data sources

I have a stock card report then I have 2 different data sources: mysql and mssql. I will get the stock item on the mysql and the number of stocks in the mssql. My question is, Is this possible using ireport and jasperserver? 

ely78144's picture
Joined: May 18 2016 - 10:08pm
Last seen: 4 years 10 months ago

1 Answer:

Yes, it is possible to use multiple/different data sources in the same parent report using sub-data sets or subreports. So one subreport or data set for stock item and another for number of stocks. And if necessary, you can return a value from a subreport and pass it to another. However, if you need to mix and match data from multiple sources in the same dataset, this will have to be done programmatically via Java or other. 

Hope this helps. 

darth_fader's picture
Joined: Mar 7 2010 - 9:45pm
Last seen: 1 week 2 days ago