Records duplicates in table
Posted on December 26, 2022 at 2:03pm
Hello everyone.
I designed an invoice with Jasper iReport Designer 5.5.0. but every record it's duplicated several times like 18, 40 even 1000 times.
I'm using Microsoft Sql Server to get the data.
In the next table the unique record is repeat several times and I wonder why.
If someone know the issue, it would be so helpful for me.
Joined: Dec 26 2022 - 12:08pm
Last seen: 5 months 1 week ago
Posted on December 29, 2022 at 10:44am
The records displayed in a report is driven by the query. I find that if duplicate records are being produced it is a result of a poorly formed query.
I agree with mahadiosb that posting the jrxml (as well as the query) may help identify the issue.
Joined: Jul 31 2017 - 3:51pm
Last seen: 2 days 15 hours ago
Please attached report JRXML file.
And Is duplicate data shown in your query?