Wow...thanks for a great response, it is as detailed as it can get, and i designed the report exactly as you suggested it worked fine. It is quite fast than the subreport too, i will try and use this I had a question regarding subreport, how do you attach a subreport to the main report on the jasper server, since i could so all the development using the subreport on the ireports, but once i exported it to my repository it causes all error saying that the subreport does not exists? Thanks once again!!!