System SSRS lines duplicating

Kinetic ERP
1

hi Folks
I have a system SSRS report for SubCon shipments that has been extended to pass custom data from the part table to the report.
i can see the data being sent from the report definition without issue

but in the ssrs report, it is duplicating the subshipD line data, and i can see no logical reason why

anyone spot an issue with below?

="SELECT T1.LegalNumber,T1.PackNum,T1.ShipComment as SubShipH_ShipComment,T1.ShipDate,T1.Calc_ContactName,T1.Calc_NumRecordPerPage,T1.Calc_ShipToAddr,T1.ShipViaCode_Description,T1.VendorNum_EMailAddress,T1.VendorNum_FaxNum,T1.VendorNum_PhoneNum,CAST( T1.Calc_NumTotalPart as nvarchar ) as Calc_NumTotalPart, T2.AssemblySeq,T2.JobNum,T2.LineDesc,T2.OprSeq,T2.PackLine,CAST( T2.Calc_DspLine as nvarchar ) as Calc_DspLine,
T2.PartNum,T2.POLine,T2.PONum,T2.PORelNum,T2.ShipComment as ShipComment,T2.Calc_DspSerialNumber,CAST( T2.Calc_DspShipQty as float ) as Calc_DspShipQty,T2.Calc_DspShipUOM,T2.Calc_GetNextLegalNum,T2.Calc_NextLegalNumber,T2.Calc_SerialNumLabl,T2.Calc_CommodityCode,T2.Calc_AttributeSetShortDescription,T2.RevisionNum,
T3.RptLiteralsLblSrlNums as RptLiteralsCalc_DspSerialNumber,T3.RptLiteralsLLine as RptLiteralsPOLine,T3.PONum as RptLiteralsPONum,T3.PORelNum as RptLiteralsPORelNum,T3.RptLiteralsLAsm,
T3.RptLiteralsLDesc,T3.RptLiteralsLFax,T3.RptLiteralsLHdngPackSlip,T3.RptLiteralsLJob,T3.RptLiteralsLLegalNumber,T3.RptLiteralsLLine,T3.RptLiteralsLOf,T3.RptLiteralsLOpr,T3.RptLiteralsLPackSlip,
T3.RptLiteralsLPage,T3.RptLiteralsLPartNum,T3.RptLiteralsLPhone,T3.RptLiteralsLShipDt,T3.RptLiteralsLShippedQty,T3.RptLiteralsLShipTo,T3.RptLiteralsLShipVia,T3.RptLiteralsLComeFrom,T3.RptLiteralsLContinueInNext,
T3.RptLiteralsLCommodityCode,T3.RptLiteralsLAttributeSet,T3.RptLiteralsLRevision,T4.Character03 
 FROM SubShipH_" + Parameters!TableGuid.Value + " T1
 LEFT OUTER JOIN SubShipD_" + Parameters!TableGuid.Value + " T2
  ON T1.Company = T2.Company AND T1.PackNum = T2.PackNum
 LEFT OUTER JOIN RptLabels_" + Parameters!TableGuid.Value + " T3
  ON T1.RptLanguageID = T3.RptLanguageID
  LEFT OUTER JOIN Part_ " + Parameters!TableGuid.Value + ") T4
  ON T4.Company = T2.Company and T4.PartNum = T2.PartNum"

its all standard apart from

  LEFT OUTER JOIN Part_ " + Parameters!TableGuid.Value + ") T4
  ON T4.Company = T2.Company and T4.PartNum = T2.PartNum"

and the selection of T4.Character03

2

Could it be that your pack num (your packing slip) has more than one line? One of the fields must be causing the duplicates. I would scan through all the fields. Then build it in BAQ to prove it returns the correct data. It could be a value hiding in a field you didn’t expect.

3

yes i am being a fool ! - again, duplicate lines in data :slight_smile: