Why my data keeps on looping

[wkindele]

Hi Guys,

I really need help, I have set up a dataset and a table in my design, the data is coming from the database, but my problem is some columns have data looping more than once.

Kindly help me.

[nardao]

This type of problems need a "DEBUG", first of all, I would start by check data. I believe that your information is already coming in this way, can you check the data without interference from Jasper, running the query directly in database?

 

In the case o the data are correct, I would make an simple Report, whithout any complex components. Only execute the query and put the fields in the Detail Band.

 

Do this things and post the return here.

 

Regards!

[nardao]

.