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.
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.
Please attached report JRXML file.
And Is duplicate data shown in your query?