chandra_anand Posted August 27, 2019 Share Posted August 27, 2019 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..! Link to comment Share on other sites More sharing options...
C-Box Posted August 27, 2019 Share Posted August 27, 2019 Not sure if I understood correct...but in general: how should the second subreport know what eventually the first subreport has already printed?!? That's not possible with the simple PrintRepeatedValue flag.Perhaps you could described more in detail what data are common and when they should surrpressed.E.g. perhaps you could pass a flag to the second subreport for filtering duplicate values out? Perhaps you could modify your sql-query already to exlude results from the first subreport.... so many potential solutions, if the problem is really known. :-)So perhaps just post some screenshots to understand the problem.hth + regardsC-Box Link to comment Share on other sites More sharing options...
chandra_anand Posted August 28, 2019 Author Share Posted August 28, 2019 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.comxy@gmail.combc@gmail.com2nd subreport is printing Borrower Email address from Esign table which is giving me unique value like:ac@gmail.comyz@gmail.comab@gmail.combc@gmail.comHere 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.comxy@gmail.combc@gmail.comac@gmail.comyz@gmail.comab@gmail.combc@gmail.comNow 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now