Hello Everyone,
I need some assistance in adding table to expression. I added the Part and the JobHead Table and need to add the expression to populate on my form.
This is what I got from UTube but it doesn’t work for me.
I added only part as shown below in displaying T4:
Thanks in advance.
Miguel
You want it to be
T2.Company = T4.Company AND T2.PartNum = T4.PartNum
Hello John,
The file errored when attempting to upload.
I added the text in the red boxes, there is probably an error on my part (see below)
The “ after T3.RptLanguageID need to be moved to the end of the statement, T4.PartNum”
I marked up your drawing to show where I changed things and also wrote it out below (beware of typos!). The first thing is that every field listed must have a comma after it, except for the last field in the list. The " at the end of the original block is the end of the code area, so adding data in requires the " to be moved to the new end. You don’t need another FROM, you are piggy backing off of the first one, so you can just add what I boxed.
T3.RptLiteralsLblPCID,
T3.RptLiteralsLCommodityCode,
T3.RptLiteralsLEORNumber,
T3.RptLiteralsLblAttributeSet,
T4.Character01
FROM ShipHead" + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN ShipDtl_" + 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 T2.Company = T4.Company AND t2.PartNum = T4.PartNum"
Hello John,
I am getting an error when I add. This is what I am putting in.
(See below)
Thank you.
You have an extra where I circled, delete that and try again.
Hello John,
I made the change and now I get a different error. (See below)
Thank you.
Miguel
I think you would have to post the complete query definition for someone to be able to help on this one.
Hello Everyone,
I am still having issues trying to add the Part Table to my query.
This is the error I get when I run the query:
Below is my entire query:
=“SELECT
T1.Company,
T1.LegalNumber,
T1.PackNum,
CAST( T1.CustNum as nvarchar ) as CustNum,
T1.ShipComment,
T1.ShipDate,
T1.Calc_BilContct,
T1.Calc_BillToAddress,
T1.Calc_SoldToAddress,
T1.Calc_Contct,
T1.Calc_CustPartOpts,
T1.Calc_FOBDescription,
T1.Calc_LegalNum,
T1.Calc_NumRecordPerPage,
T1.Calc_NumTotalParts,
T1.Calc_SalesRepName,
T1.Calc_ShipToAddress,
T1.Calc_ShipViaDescription,
T1.Calc_stPhone,
T1.Calc_CusPhone,
T1.Calc_stFax,
T1.Calc_EMailAddress,
T1.Calc_FaxNum,
T1.Calc_SEmailAddr,
T1.Calc_CarrierDesc,
T1.Calc_ShipViaSCAC,
T1.Calc_CarrierSCAC,
T1.Calc_CompanyEORINumber,
T1.Calc_CustShipToEORINumber,
T1.TrackingNumber,
T2.PackLine,
T2.Discount,
T2.ExtPrice,
T2.HeaderShipComment,
T2.LineDesc,
T2.OrderLine,
T2.OrderNum,
T2.OrderRelNum,
T2.PartNum,
T2.RevisionNum,
T2.ShipComment as ShipDtl_ShipComment,
T2.UnitPrice,
T2.XPartNum,
T2.XRevisionNum,
T2.Calc_DspBackOrdQty,
T2.Calc_DspBackOrdQtyUom,
T2.Calc_DspLabDur,
T2.Calc_DspLabMod,
T2.Calc_DspLineDesc,
T2.Calc_DspLineShpQty,
T2.Calc_DspLineShpQtyUom,
T2.Calc_DspMatDur,
T2.Calc_DspMatMod,
T2.Calc_DspMiscDur,
T2.Calc_DspMiscMod,
T2.Calc_DspPlannedQty,
T2.Calc_DspPlannedQtyUom,
T2.Calc_DspSerialNumber,
T2.Calc_DspShipRouting,
T2.Calc_DspSubShipTo,
T2.Calc_GetNextLegalNum,
T2.Calc_LegalText,
T2.Calc_LinChangd,
T2.Calc_NextLegalNumID,
T2.Calc_NumLineByInv,
T2.Calc_OrdRelRef,
T2.Calc_POLine,
T2.Calc_SalesRepName as ShipDtl_Calc_SalesRepName,
T2.Calc_SerialNumLabl,
T2.Calc_TotalLineCost,
T2.Calc_TotalTax,
T2.Calc_HidePackLine,
T2.OrderLine_KitFlag,
T2.OrderLine_KitParentLine,
T2.OrderLine_KitPrintCompsPS,
T2.OrderLine_DisplaySeq,
T2.OrderLine_KitShipComplete,
T2.Calc_MarkForAddress,
T2.OrderNum_PONum,
T2.PartNum_PartDescription,
T2.PCID,
T2.Calc_CommodityCode,
T2.Calc_AttributeSetShortDesc,
T2.Calc_TrackByAttribute,
T2.ShortChar01,
T2.Character03,
T3.RptLiteralsLblDescription,
T3.RptLiteralsLblFax,
T3.RptLiteralsLblEmail,
T3.RptLiteralsLblRel,
T3.RptLiteralsLblPh,
T3.RptLiteralsLblPO,
T3.RptLiteralsLblRev,
T3.RptLiteralsHComponents,
T3.RptLiteralsLblBckOrQty,
T3.RptLiteralsLblCustPart,
T3.RptLiteralsLblDiscAmt,
T3.RptLiteralsLblExtendedPrice,
T3.RptLiteralsLblFOB,
T3.RptLiteralsLblHdngPckSlip,
T3.RptLiteralsLblLbDu,
T3.RptLiteralsLblLine,
T3.RptLiteralsLblMiDu,
T3.RptLiteralsLblMtDu,
T3.RptLiteralsLblOurPrt,
T3.RptLiteralsLblPackSlip,
T3.RptLiteralsLblPage,
T3.RptLiteralsLblPlndQty,
T3.RptLiteralsLblPoLine,
T3.RptLiteralsLblPrtNum,
T3.RptLiteralsLblReference,
T3.RptLiteralsLblSalesOrder,
T3.RptLiteralsLblSalesperson,
T3.RptLiteralsLblShipDt,
T3.RptLiteralsLblShipRouting,
T3.RptLiteralsLblShipTo,
T3.RptLiteralsLblShipVia,
T3.RptLiteralsLblShpdQty,
T3.RptLiteralsLblSoldTo,
T3.RptLiteralsLblSrlNum,
T3.RptLiteralsLblSrlNums,
T3.RptLiteralsLblSubShipTo,
T3.RptLiteralsLblTotalLineCost,
T3.RptLiteralsLblTotalTax,
T3.RptLiteralsLblUnitPrice,
T3.RptLiteralsLblYourPO,
T3.RptLiteralsLLegalText,
T3.RptLiteralsLLegNum,
T3.RptLiteralsLSalesKit,
T3.RptLiteralsLCarrierSCAC,
T3.RptLiteralsLCarrier,
T3.RptLiteralsLblShipViaSCAC,
T3.RptLiteralslblInvNumber,
T3.RptLiteralslblInvDueDate,
T3.RptLiteralsLblOf,
T3.RptLiteralsLblContinueOnNext,
T3.RptLiteralsLblComeFrom,
T3.RptLiteralsLblPCID,
T3.RptLiteralsLCommodityCode,
T3.RptLiteralsLEORINumber,
T3.RptLiteralsLblAttributeSet,
T4.Character01
FROM ShipHead_” + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN ShipDtl_" + 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 T2.Company = T4 Company AND T2.PartNum = T4.PartNum"
Thanks in Advance,
Miguel
You Missed the .(DOT) it should be T4.Company
Hello Patel,
Thanks for your help. Unfortunately, the error still exists.
Miguel
That also says Parameteres! instead of Parameters!