chandra_anand

Let me clarify ths: This is related to XML path not sql query. I am providing XML path in datasource expression of both subreport. XML path is different in both subreport. 1st subreport is printing Borrower Email address from Borrower table which is giving me unique value like: ab@gmail.com xy@gmail.com bc@gmail.com 2nd subreport is printing Borrower Email address from Esign table which is giving me unique value like: ac@gmail.com yz@gmail.com ab@gmail.com bc@gmail.com Here when I am including both subreport on Main jrxml file then it is printing all email address from 1st subreport and 2nd subreport like this: ab@gmail.com xy@gmail.com bc@gmail.com ac@gmail.com yz@gmail.com ab@gmail.com bc@gmail.com Now ab@gmail.com and bc@gmail.com is printing twice here. I want to print this at one time only. Want to remove the duplicate one. How to remove this? Please suggest.

Hello, I have created a subreport having a datasource expression and removing the duplicate values by deactivate Print Repeated Value which give me Unique value. Again I have created another subreport having different datasource expression and removing the duplicate values by deactivate Print Repeated Value which give me Unique value. However when I am putting this on Main jassper it is giving me repeated values because of there are common values available in 1st and 2nd subreport. How would I remove the common values from these 2 subreport? Please suggest as it is urgent. Appreciate you in advance..!