Using left join cause the data duplicate

[sl5310520]

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?

 

[Tarun Gupta]

hey,,

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