I found alternative. Perhaps, its an hack. As, I have mentioned in my question that you cant have sub-dataset to single cell. To accomplish multiple queries in report use different tables with sub-datasets.
Bottom line is that you can't have sub-datsets in Jasper iReport.
-Thank you