Getting a data from 2 different data sources

[ely78144]

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? 

[darth_fader]

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.