Hi J S againHere you have the cancelled documents. SELECT * FROM
(SELECT * FROM OJDT T0
Where T0."StornoToTr" <> 0
UNION ALL
SELECT * FROM OJDT T1
Where T1."TransId" IN
(SELECT T0."StornoToTr" FROM OJDT T0
Where T0."StornoToTr" <> 0)
) AA
Where...
Hi Nagarajan You have to include the attached file into the Crystal Report. I coudn't get to change it dinamically, but the is some addin software for that in CR.Please let me know if you solve it.Regards,Augusto
Hi! You may relate the tables with the fields TransType and TransId in the OVPM Table.select * from OJDT t0
inner join OVPM t1 on T0."TransType" = '46'
and t1."TransId" = t0."TransId"
where T1."DocType" = 'D' and T1."Canceled"='N'
/*If you want t...
