Skip to Content
Jun 23, 2016 at 06:36 AM

Serial Number in Crystal report


Dear All,

I have created the crystal report for Delivery document with item description and serial number. But it's shows all serial number. When i'm giving print layout from delivery document the report should show serial number related to that particular delivery document not for all.

I have using the below query,

SELECT T0.[DocNum],T0.[Series],T1.[Dscription],T4.[DistNumber]

FROM Odln T0 INNER JOIN dln1 T1 ON T0.[DocEntry] = T1.[DocEntry]

left outer join SRI1 I1 on T1.ItemCode=I1.ItemCode and (T1.DocEntry=I1.BaseEntry and T1.ObjType=I1.BaseType)

left outer join OSRN T4 on T4.ItemCode=I1.ItemCode and I1.SysSerial=T4.SysNumber

I have a confusion in joins, can anyone help me???


Prabakaran R