I am trying to create a layout in crystal reports for an inventory transfer and need to reference FROM BIN and TO BIN.
at the moment i am joining like this
select * from OWTR inner join WTR1 on OWTR.DocEntry = WTR1.DocEntry
left outer join OILM on WTR1.LineNum = OILM.DocLineNum
left outer join OBTL on OILM.MessageID = OBTL.MessageID
left outer join OBIN on OBTL.BinAbs = OBIN.AbsEntry
where OILM.transtype = 67
has anyone done this sort of layout before?