To remove duplicate values from two subreport

0

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..!

chandra_anand's picture
Joined: Aug 26 2019 - 11:37pm
Last seen: 1 month 3 weeks ago

2 Answers:

0

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

C-Box

C-Box's picture
1965
Joined: Jul 19 2006 - 5:58pm
Last seen: 15 hours 21 min ago
0

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.

chandra_anand's picture
Joined: Aug 26 2019 - 11:37pm
Last seen: 1 month 3 weeks ago
Feedback
randomness