Hello,
I've created a report in Crystal Reports using the following query. The report works in Crystal, but when I save it and import it into a B1 as a layout none of the data populates.
INNER JOIN IGE1 T1 ON T0."DocEntry" = T1."DocEntry" LEFT JOIN OITM T2 ON T1."ItemCode" = T2."ItemCode" LEFT JOIN "DATABASE"."@U_BATCHES" T3 ON T0."DocEntry" = T3."U_DocEntry" AND T1."ItemCode" = T3."U_ItemCode" LEFT JOIN OITW T4 ON T2."ItemCode" = T4."ItemCode" LEFT JOIN OBIN T5 ON T4."DftBinAbs" = T5."AbsEntry" WHERE T5."WhsCode" = '01' and T0."DocNum" = {?DocKey@} ORDER BY T1."BaseRef", T1."BaseLine"