Sir/Madam
We have the following script.

select tdpcl105.*
from tdpcl105
where tdpcl105.ttyp = :tdsls045.ttyp
and tdpcl105.invn = :tdsls045.invn
and tdpcl105.cono = :i
selectdo
endselect

In the report we get following problem.
Inv No 105Inv No
ABC 20090001 ZZ 20090093
ABC 20090002 ZZ 20090093

Inv No ABC 20090001, ABC 20090002 come frm tdsls045 & ZZ 20090093 come frm tdpcl105.
Tdpcl105 has ABC 20090001 & matching ZZ 20090093, the nxt record in tdpcl105 is
ABC 20090003 & has matching ZZ 20090094.
Tdpcl105 does not has any record for corresponding ABC 20090002.
So in report we should have blank space in column 105Inv No in case of ABC 20090002.
But in our report it is giving value ZZ 20090093 instead of space, which is incorrect.
Pls help.
We have already selected records frm tdsls045 before giving this script for tdpcl105
Regards
Django

Try to clean the used field values from tdplc105 before the select. I guess the values from the previous record set are presented in the next record.

For example ( I don't know the field names you use from tdplc105 )

tdplc105.ttyp = ""
tdplc105.invn = ""

select tdpcl105.*
from tdpcl105
where tdpcl105.ttyp = :tdsls045.ttyp
and tdpcl105.invn = :tdsls045.invn
and tdpcl105.cono = :i
selectdo
endselect

Good luck!

JP