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..!
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 + regards
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:
2nd subreport is printing Borrower Email address from Esign table which is giving me unique value like:
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:
How to remove this? Please suggest.