Using left join cause the data duplicate


What I want is like:

Earnings Amount Deductions Amount
Total OT Pay 157.34 Late 100
Room 100    
Transport 100    

But the output is like:


Everything is correct , the problem is only the Deductions column will keep repeat same data,

But seem cannot write multiple select statement on ireport, how to solve this problem?

Anything i need to provide?


sl5310520's picture
Joined: Oct 5 2015 - 5:56pm
Last seen: 4 years 11 months ago

1 Answer:



You can use DISTINCT in ur query but it apply all in ur query,,,,,and in report field properties (show in image )  You check print repeated values but when u apply this its blank a full row ,,

i think its solve your problem

Tarun Gupta's picture
Joined: Jun 17 2015 - 4:11am
Last seen: 4 years 9 months ago