I am trying to add columns to our pack slip for job lot number. When I go to add in T2.[LotNum] as ReqLotNum I am not allowed to add more characters to the query expression.
What is the best way to add in the required column not using the Query Expression?
What is the best way to reduce the size of the query expression?
I am in gov cloud, so I do not believe I have direct sql access.
Remove any columns not used by the report. Try copying the query expression to a text editor, and removing unneeded spaces and line breaks. Then paste that back into the Query expression.
For example
="SELECT T1.Company, T1.PartNum, T1.Description FROM Part_" + Parameters!TableGuid.Value + T1"
is 96 characters where as
="SELECT T1.Company,T1.PartNum,T1.Description FROM Part_"+Parameters!TableGuid.Value+T1"
is only 88
That was done by
+ in the part that builds the table nameFROM keyword with a space.You may also be able to edit the RDL file in a Text editor.
Not sure if I just got lucky or if the query expression is always near the top:
(FWIW - that one is NOT optimized for query expression length. I purposely made it longer for easier reading, for another post on here)
VS Code has an extension that will pretty XML files like RDL called XML Tools
Once installed, right mouse click inside your document:
Choose Format Document Withā¦ And choose XML Tools:
Yall are on it! Here is what my pack slip query expression looks like:
=ā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, 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,
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
, T1.[AGAuthorizationCode], T1.[AGAuthorizationDate], T1.[AGCarrierCUIT], T1.[AGCOTMark], T1.[AGDocumentLetter], T1.[AGInvoicingPoint], T1.[AGLegalNumber], T1.[AGPrintingControlType], T1.[AGShippingWay], T1.[AGTrackLicense], T1.[ASNPrintedDate], T1.[AutoPrintReady], T1.[CreatedOn], T1.[DigitalSignature], T1.[DispatchReason], T1.[DocCopyNum], T1.[DocOrderAmt], T1.[EDIShipToNum], T1.[FirstPrintDate], T1.[LabelComment], T1.[MXIncoterm], T1.[OurSupplierCode], T1.[PkgCode], T1.[ShipOvers], T1.[ShipPerson], T1.[SignedBy], T1.[SignedOn], T1.[TrackingNumber], T1.[Weight], T1.[WIPackSlipCreated], T1.[Calc_AGAFIPResponsibilityDesc], T1.[Calc_AGShipToResaleID], T1.[Calc_AGShipViaAddress], T1.[Calc_AGShipViaAFIPResponsibilityDesc], T1.[Calc_BAddr1], T1.[Calc_BAddr2], T1.[Calc_BAddr3], T1.[Calc_BCity], T1.[Calc_BName], T1.[Calc_BState], T1.[Calc_BZipCode], T1.[Calc_CurrName], T1.[Calc_CustId], T1.[Calc_PhoneNum], T1.[Calc_PoNum], T1.[Calc_RptUsedID], T1.[Calc_SAddr1], T1.[Calc_SAddr2], T1.[Calc_SAddr3], T1.[Calc_SCity], T1.[Calc_SName], T1.[Calc_SState], T1.[Calc_SZipCode], T1.[Calc_TermsDescription], T1.[Calc_WeightGrossWords], T1.[Calc_WeightWords], T1.[Customer_AGAFIPResponsibilityCode], T1.[Customer_BTName], T1.[Customer_CustID], T1.[Customer_EMailAddress], T1.[Customer_FaxNum], T1.[Customer_Name], T1.[Customer_ResaleID], T1.[Customer_TradingPartnerName], T1.[PkgSizeUOM_UOMSymbol], T1.[ShipToCust_BTName], T1.[ShipToCust_CustID], T1.[ShipToCust_Name], T1.[ShipToCust_ResaleID], T1.[ShipViaCode_Description], T1.[ShipViaCode_WebDesc], T1.[TranDocType_Description], T1.[WeightUOM_UOMSymbol], T2.[AllowedOvers], T2.[AllowedUnders], T2.[CustContainerPartNum], T2.[DocDiscount], T2.[DocExtPrice], T2.[DocInExtPrice], T2.[DockingStation], T2.[DocUnitPrice], T2.[FSAEquipment], T2.[JobLotNum], T2.[LabelType], T2.[NotAllocatedQty], T2.[OTMFContact], T2.[OTMFFaxNum], T2.[OTMFPhoneNum], T2.[Packages], T2.[PCIDItemSeq], T2.[PCIDParentLine], T2.[PkgCodePartNum], T2.[RenewalNbr], T2.[SalesUM], T2.[TotalNetWeight], T2.[UseShipDtlInfo], T2.[WarrantySendToFSA], T2.[Calc_DocTotalTax], T2.[Calc_DspBackOrdQtyUom_UOMSymbol], T2.[Calc_DspDimQty], T2.[Calc_DspInvShpQty], T2.[Calc_DspJobShpQty], T2.[Calc_DspLabelNum], T2.[Calc_DspLineShpQtyUom_UOMDesc], T2.[Calc_DspLineShpQtyUom_UOMSymbol], T2.[Calc_DspMiscAmt], T2.[Calc_DspMiscCode], T2.[Calc_DspMiscDesc], T2.[Calc_DspMiscSeq], T2.[Calc_DspOrdRelJobShpQty], T2.[Calc_DspOrdRelStkShpQty], T2.[Calc_DspPackLine], T2.[Calc_DspPkgCode], T2.[Calc_DspPkgDesc], T2.[Calc_DspPlannedQtyUom_UOMSymbol], T2.[Calc_DspUnitPrice], T2.[Calc_DspWarrDesc], T2.[Calc_GrossWeight], T2.[Calc_GrossWeightUOM], T2.[Calc_JobHUDChr1], T2.[Calc_JobHUDChr2], T2.[Calc_JobHUDChr3], T2.[Calc_JobHUDChr4], T2.[Calc_JobHUDDat1], T2.[Calc_JobHUDDat2], T2.[Calc_JobHUDDat3], T2.[Calc_JobHUDDat4], T2.[Calc_JobHUDDec1], T2.[Calc_JobHUDDec2], T2.[Calc_JobHUDInt1], T2.[Calc_JobHUDInt2], T2.[Calc_OrdDtlRef], T2.[Calc_OrdrUDChr1], T2.[Calc_OrdrUDChr2], T2.[Calc_OrdrUDChr3], T2.[Calc_OrdrUDChr4], T2.[Calc_OrdrUDDat1], T2.[Calc_OrdrUDDat2], T2.[Calc_OrdrUDDat3], T2.[Calc_OrdrUDDat4], T2.[Calc_OrdrUDDec1], T2.[Calc_OrdrUDDec2], T2.[Calc_OrdrUDInt1], T2.[Calc_OrdrUDInt2], T2.[Calc_PartUDChr1], T2.[Calc_PartUDChr2], T2.[Calc_PartUDChr3], T2.[Calc_PartUDChr4], T2.[Calc_PartUDDat1], T2.[Calc_PartUDDat2], T2.[Calc_PartUDDat3], T2.[Calc_PartUDDat4], T2.[Calc_PartUDDec1], T2.[Calc_PartUDDec2], T2.[Calc_PartUDDec3], T2.[Calc_PartUDDec4], T2.[Calc_PartUDInt1], T2.[Calc_PartUDInt2], T2.[Calc_ShippedCUMMDate], T2.[Calc_ShippedCUMMQty], T2.[Calc_ShippedQtyPack], T2.[Calc_ShippedUomPack], T2.[Calc_ShippedUomPack_UOMSymbol], T2.[ContractCode_ContractDescription], T2.[CustNum_BTName], T2.[CustNum_CustID], T2.[CustNum_Name], T2.[CustNum_TradingPartnerName], T2.[Dimension_DimCodeDescription], T2.[InventoryShipUOM_UOMSymbol], T2.[IUM_UOMSymbol], T2.[JobNum_PartDescription], T2.[JobShipUOM_UOMSymbol], T2.[Lot_PartLotDescription], T2.[OrderLine_KitAllowUpdate], T2.[OrderLine_KitBackFlush], T2.[OrderLine_KitPricing], T2.[OrderLine_KitPrintCompsInv], T2.[OrderLine_KitQtyPer], T2.[OrderLine_KitsLoaded], T2.[OrderLine_OrderLine], T2.[OrderLine_OrderNum], T2.[OrderNum_CardMemberName], T2.[OrderRelNum_MarkForNum], T2.[OrderRelNum_OpenRelease], T2.[OrderRelNum_OrderLine], T2.[OrderRelNum_OrderNum], T2.[OrderRelNum_OrderRelNum], T2.[OrderRelNum_RAN], T2.[OrderRelNum_Reference], T2.[PartNum_MfgComment], T2.[PartNum_PurComment], T2.[PartNum_TrackDimension], T2.[PartNum_TrackLots], T2.[PartNum_TrackSerialNum], T2.[PartNum_UPCCode1], T2.[PartNum_UPCCode2], T2.[PartNum_UPCCode3], T2.[SalesUM_UOMSymbol], T2.[WarehouseCode_Description], T2.[WarrantyCode_WarrDescription], T2.[WIPWarehouseCode_Description], T2.[WUM_UOMSymbol], T3.[DecimalsGeneral] as RptLabelsDecimalsGeneral, T3.[DecimalsPrice] as RptLabelsDecimalsPrice, T3.[DecimalsCost] as RptLabelsDecimalsCost, T3.[GlbDecimalsGeneral] as RptLabelsGlbDecimalsGeneral, T3.[GlbDecimalsPrice] as RptLabelsGlbDecimalsPrice, T3.[GlbDecimalsCost] as RptLabelsGlbDecimalsCost, T3.[RptLiteralsPage], T3.[RptLiteralsTime], T3.[RptLiteralsUser], T3.[RptLiteralsDate], T3.[RptLiteralsLAGAFIPRespons], T3.[RptLiteralsLAGCAI], T3.[RptLiteralsLAGCUIT], T3.[RptLiteralsLAGDocumentNotValid], T3.[RptLiteralsLAGIIBB], T3.[RptLiteralsLAGIssueDate], T3.[RptLiteralsLAGREMITO], T3.[RptLiteralsLblDesc], T3.[RptLiteralsLblLegalNumber], T3.[RptLiteralsLblMarkForAddress], T3.[RptLiteralsLblMscAmt], T3.[RptLiteralsLblMscCd], T3.[RptLiteralsLblMscDesc], T3.[RptLiteralsLblPart], T3.[RptLiteralsLblPkgCod], T3.[RptLiteralsLblPkgDesc], T3.[RptLiteralsLblQty], T3.[RptLiteralsLblQuantity], T3.[RptLiteralsLblRef], T3.[RptLiteralsLblRevision], T3.[RptLiteralsLblSalesPer], T3.[RptLiteralsLblSO], T3.[RptLiteralslblTotalMiscCharges], T3.[RptLiteralsLblUOM], T3.[RptLiteralsLblWeight], T3.[RptLiteralsLblWt], T3.[RptLiteralsLComponents], T3.[RptLiteralsLDate], T3.[RptLiteralsLImportedFrom], T3.[RptLiteralsLImportNum], T3.[RptLiteralsLKit], T3.[RptLiteralsLKitSeq], T3.[RptLiteralsLNumber], T3.[RptLiteralsLRUAccNo], T3.[RptLiteralsLRUAmountRubCop], T3.[RptLiteralsLRUAmountWithoutVAT], T3.[RptLiteralsLRUAttorneyByWhom], T3.[RptLiteralsLRUAttorneyNumber], T3.[RptLiteralsLRUBIC], T3.[RptLiteralsLRUByOKPO], T3.[RptLiteralsLRUCargoApprovedBy], T3.[RptLiteralsLRUCargoReceivedBy], T3.[RptLiteralsLRUChiefAccountant], T3.[RptLiteralsLRUCode], T3.[RptLiteralsLRUCodeS], T3.[RptLiteralsLRUCompanyAdress], T3.[RptLiteralsLRUConsignmentNote], T3.[RptLiteralsLRUConsignorCompany], T3.[RptLiteralsLRUContractOrder], T3.[RptLiteralsLRUCorrAccNo], T3.[RptLiteralsLRUDate], T3.[RptLiteralsLRUDateOfPreparation], T3.[RptLiteralsLRUDELIVERYNOTE], T3.[RptLiteralsLRUDepartment], T3.[RptLiteralsLRUDescAndProps], T3.[RptLiteralsLRUDocumentNo], T3.[RptLiteralsLRUDoneBy], T3.[RptLiteralsLRUFax], T3.[RptLiteralsLRUFormByOKUD], T3.[RptLiteralsLRUFrom], T3.[RptLiteralsLRUGoods], T3.[RptLiteralsLRUGoodsReceiver], T3.[RptLiteralsLRUGrandTotal], T3.[RptLiteralsLRUGrossWeight], T3.[RptLiteralsLRUGrossWeightTotal], T3.[RptLiteralsLRUINN], T3.[RptLiteralsLRUInOnePack], T3.[RptLiteralsLRUInWords], T3.[RptLiteralsLRUIssued], T3.[RptLiteralsLRUKPP], T3.[RptLiteralsLRULineNo], T3.[RptLiteralsLRULines], T3.[RptLiteralsLRUName], T3.[RptLiteralsLRUNetWeightTotal], T3.[RptLiteralsLRUNo], T3.[RptLiteralsLRUOfYear], T3.[RptLiteralsLRUOKDPActivityCode], T3.[RptLiteralsLRUOKEICode], T3.[RptLiteralsLRUOperationType], T3.[RptLiteralsLRUOrder], T3.[RptLiteralsLRUPacks], T3.[RptLiteralsLRUPackType], T3.[RptLiteralsLRUPages], T3.[RptLiteralsLRUPagesAndContains], T3.[RptLiteralsLRUPageTotal], T3.[RptLiteralsLRUPayer], T3.[RptLiteralsLRUPh], T3.[RptLiteralsLRUPlaceOfSeal], T3.[RptLiteralsLRUPlantManager], T3.[RptLiteralsLRUPosition], T3.[RptLiteralsLRUPriceRubCop], T3.[RptLiteralsLRUPrintName], T3.[RptLiteralsLRUQuantity], T3.[RptLiteralsLRUQuantityNetWeight], T3.[RptLiteralsLRURatePercent], T3.[RptLiteralsLRUReason], T3.[RptLiteralsLRUReceivedBy], T3.[RptLiteralsLRUReverseSideNote], T3.[RptLiteralsLRUSignature], T3.[RptLiteralsLRUStatutoryRef1], T3.[RptLiteralsLRUSupplements], T3.[RptLiteralsLRUSupplementsPages], T3.[RptLiteralsLRUSupplier], T3.[RptLiteralsLRUTotalIncludingVAT], T3.[RptLiteralsLRUTotalPacks], T3.[RptLiteralsLRUTotGoodsIssdAmnt], T3.[RptLiteralsLRUUnifiedFormName], T3.[RptLiteralsLRUUnitOfMeasure], T3.[RptLiteralsLRUVAT], T3.[RptLiteralsLRUWarehouseManager], T3.[RptLiteralsLStartDate], T3.[AgingCreditClearDate] as RptLabelsAgingCreditClearDate, T3.[AgingCreditClearUserID] as RptLabelsAgingCreditClearUserID, T3.[AgingCreditCode] as RptLabelsAgingCreditCode, T3.[AgingCreditHold] as RptLabelsAgingCreditHold, T3.[AgingCreditHoldDate] as RptLabelsAgingCreditHoldDate, T3.[AgingCreditHoldSource] as RptLabelsAgingCreditHoldSource, T3.[AnnualRevenue] as RptLabelsAnnualRevenue, T3.[ConsolidateLinesPerPart] as RptLabelsConsolidateLinesPerPart, T3.[ECCType] as RptLabelsECCType, T3.[EInvEndpointIDAttr] as RptLabelsEInvEndpointIDAttr, T3.[ExternalCRMCustomerID] as RptLabelsExternalCRMCustomerID, T3.[ExternalCRMCustomerType] as RptLabelsExternalCRMCustomerType, T3.[ExternalCRMLastSync] as RptLabelsExternalCRMLastSync, T3.[ExternalCRMSyncRequired] as RptLabelsExternalCRMSyncRequired, T3.[ImporterOfRecord] as RptLabelsImporterOfRecord, T3.[Industry] as RptLabelsIndustry, T3.[INGSTComplianceRate] as RptLabelsINGSTComplianceRate, T3.[INTaxRegistrationID] as RptLabelsINTaxRegistrationID, T3.[MXAccountNumber] as RptLabelsMXAccountNumber, T3.[MXCURP] as RptLabelsMXCURP, T3.[MXGeneralPublic] as RptLabelsMXGeneralPublic, T3.[MXPurchaseType] as RptLabelsMXPurchaseType, T3.[MYIndustryCode] as RptLabelsMYIndustryCode, T3.[NumberOfEmployees] as RptLabelsNumberOfEmployees, T3.[OurSupplierCode] as RptLabelsOurSupplierCode, T3.[Ownership] as RptLabelsOwnership, T3.[PEAddressID] as RptLabelsPEAddressID, T3.[PEPerceptionRegime] as RptLabelsPEPerceptionRegime, T3.[Rating] as RptLabelsRating, T3.[SendToFSA] as RptLabelsSendToFSA, T3.[SyncToExternalCRM] as RptLabelsSyncToExternalCRM, T3.[TaxEntityType] as RptLabelsTaxEntityType, T3.[TickerLocation] as RptLabelsTickerLocation, T3.[TickerSymbol] as RptLabelsTickerSymbol, T3.[TWDeductGUIFormatCode] as RptLabelsTWDeductGUIFormatCode, T3.[TWGUIRegNum] as RptLabelsTWGUIRegNum, T3.[TWTaxPayerType] as RptLabelsTWTaxPayerType, T3.[UseBlindShipping] as RptLabelsUseBlindShipping, T3.[Calc_BTLegalName] as RptLabelsCalc_BTLegalName, T3.[Calc_PackNum] as RptLabelsCalc_PackNum, T3.[MXFederalID] as RptLabelsMXFederalID, T3.[MXMunicipio] as RptLabelsMXMunicipio, T3.[PEUBIGEOCode] as RptLabelsPEUBIGEOCode, T3.[PhoneNum] as RptLabelsPhoneNum, T3.[BTName] as RptLabelsBTName, T3.[CustID] as RptLabelsCustID, T3.[Name] as RptLabelsName, T3.[OrgRegCode] as RptLabelsOrgRegCode, T3.[ResaleID] as RptLabelsResaleID, T3.[CCCity] as RptLabelsCCCity, T3.[CCState] as RptLabelsCCState, T3.[ClosedNotShipped] as RptLabelsClosedNotShipped, T3.[ExtAOE] as RptLabelsExtAOE, T3.[ExtAOEUserID] as RptLabelsExtAOEUserID, T3.[InvCurrDepositBal] as RptLabelsInvCurrDepositBal, T3.[OrderOpenCredit] as RptLabelsOrderOpenCredit, T3.[PLArticle106c] as RptLabelsPLArticle106c, T3.[PLEnforcementAuthAddr] as RptLabelsPLEnforcementAuthAddr, T3.[PLEnforcementAuthName] as RptLabelsPLEnforcementAuthName, T3.[PLGoodsOrServiceVATExempt] as RptLabelsPLGoodsOrServiceVATExempt, T3.[PLInvIssuedBySecondTaxpayer] as RptLabelsPLInvIssuedBySecondTaxpayer, T3.[PLInvIssuedByTaxpayer] as RptLabelsPLInvIssuedByTaxpayer, T3.[PLLegalArticleAct] as RptLabelsPLLegalArticleAct, T3.[PLLegalArticleOther] as RptLabelsPLLegalArticleOther, T3.[PLLegalArticleWEDirective] as RptLabelsPLLegalArticleWEDirective, T3.[PLMarginScheme] as RptLabelsPLMarginScheme, T3.[PLSecondHandOrArts] as RptLabelsPLSecondHandOrArts, T3.[PLTaxRepresentativeAddr] as RptLabelsPLTaxRepresentativeAddr, T3.[PLTaxRepresentativeName] as RptLabelsPLTaxRepresentativeName, T3.[PLTaxRepresentativeTaxID] as RptLabelsPLTaxRepresentativeTaxID, T3.[PLTouristService] as RptLabelsPLTouristService, T3.[ShipByTime] as RptLabelsShipByTime, T3.[TWFiscalPeriod] as RptLabelsTWFiscalPeriod, T3.[TWFiscalYear] as RptLabelsTWFiscalYear, T3.[TWFiscalYearSuffix] as RptLabelsTWFiscalYearSuffix, T3.[TWGUIGroup] as RptLabelsTWGUIGroup, T3.[TWGUIRegNumBuyer] as RptLabelsTWGUIRegNumBuyer, T3.[TWGUIRegNumSeller] as RptLabelsTWGUIRegNumSeller, T3.[Calc_PackLine] as RptLabelsCalc_PackLine, T3.[OrderLine] as RptLabelsOrderLine, T3.[OrderNum] as RptLabelsOrderNum, T3.[OrderRelNum] as RptLabelsOrderRelNum, T3.[Reference] as RptLabelsReference, T3.[AttBatch] as RptLabelsAttBatch, T3.[AttBeforeDt] as RptLabelsAttBeforeDt, T3.[AttCureDt] as RptLabelsAttCureDt, T3.[AttExpDt] as RptLabelsAttExpDt, T3.[AttFirmware] as RptLabelsAttFirmware, T3.[AttHeat] as RptLabelsAttHeat, T3.[AttMfgBatch] as RptLabelsAttMfgBatch, T3.[AttMfgDt] as RptLabelsAttMfgDt, T3.[AttMfgLot] as RptLabelsAttMfgLot, T3.[AttrClassID] as RptLabelsAttrClassID, T3.[BOLClass] as RptLabelsBOLClass, T3.[ChangedOn] as RptLabelsChangedOn, T3.[CNCodeVersion] as RptLabelsCNCodeVersion, T3.[CNHasPreferentialTreatment] as RptLabelsCNHasPreferentialTreatment, T3.[CNPreferentialTreatmentContent] as RptLabelsCNPreferentialTreatmentContent, T3.[CNSpecification] as RptLabelsCNSpecification, T3.[CNTaxCategoryCode] as RptLabelsCNTaxCategoryCode, T3.[CNZeroTaxRateMark] as RptLabelsCNZeroTaxRateMark, T3.[CommentText] as RptLabelsCommentText, T3.[CommercialBrand] as RptLabelsCommercialBrand, T3.[CommercialCategory] as RptLabelsCommercialCategory, T3.[CommercialColor] as RptLabelsCommercialColor, T3.[CommercialSize1] as RptLabelsCommercialSize1, T3.[CommercialSize2] as RptLabelsCommercialSize2, T3.[CommercialStyle] as RptLabelsCommercialStyle, T3.[CommercialSubBrand] as RptLabelsCommercialSubBrand, T3.[CommercialSubCategory] as RptLabelsCommercialSubCategory, T3.[Condition] as RptLabelsCondition, T3.[CreatedBy] as RptLabelsCreatedBy, T3.[CreatedOn] as RptLabelsCreatedOn, T3.[DeferAssetDisposal] as RptLabelsDeferAssetDisposal, T3.[DeferInspection] as RptLabelsDeferInspection, T3.[DeferInventoryCounts] as RptLabelsDeferInventoryCounts, T3.[DeferInventoryMove] as RptLabelsDeferInventoryMove, T3.[DeferJobReceipt] as RptLabelsDeferJobReceipt, T3.[DeferManualEntry] as RptLabelsDeferManualEntry, T3.[DeferPurchaseReceipt] as RptLabelsDeferPurchaseReceipt, T3.[DeferQtyAdjustment] as RptLabelsDeferQtyAdjustment, T3.[DeferReturnMaterials] as RptLabelsDeferReturnMaterials, T3.[DeferShipments] as RptLabelsDeferShipments, T3.[DiameterInside] as RptLabelsDiameterInside, T3.[DiameterOutside] as RptLabelsDiameterOutside, T3.[DiameterUM] as RptLabelsDiameterUM, T3.[Durometer] as RptLabelsDurometer, T3.[EngineeringAlert] as RptLabelsEngineeringAlert, T3.[ExternalCRMPartID] as RptLabelsExternalCRMPartID, T3.[ExternalMESLastSync] as RptLabelsExternalMESLastSync, T3.[ExternalMESSyncRequired] as RptLabelsExternalMESSyncRequired, T3.[FairMarketValue] as RptLabelsFairMarketValue, T3.[FSAEquipment] as RptLabelsFSAEquipment, T3.[FSAItem] as RptLabelsFSAItem, T3.[ImageID] as RptLabelsImageID, T3.[IsCompliant] as RptLabelsIsCompliant, T3.[IsGiftCard] as RptLabelsIsGiftCard, T3.[IsRestricted] as RptLabelsIsRestricted, T3.[IsSafetyItem] as RptLabelsIsSafetyItem, T3.[IsServices] as RptLabelsIsServices, T3.[LocationIDNumReq] as RptLabelsLocationIDNumReq, T3.[LocationTrackInv] as RptLabelsLocationTrackInv, T3.[MXCustomsDuty] as RptLabelsMXCustomsDuty, T3.[MXProdServCode] as RptLabelsMXProdServCode, T3.[PartLengthWidthHeightUM] as RptLabelsPartLengthWidthHeightUM, T3.[PartPhotoExists] as RptLabelsPartPhotoExists, T3.[PartSpecificPackingUOM] as RptLabelsPartSpecificPackingUOM, T3.[PEDetrGoodServiceCode] as RptLabelsPEDetrGoodServiceCode, T3.[PEProductServiceCode] as RptLabelsPEProductServiceCode, T3.[PESUNATTypeCode] as RptLabelsPESUNATTypeCode, T3.[PESUNATUOMCode] as RptLabelsPESUNATUOMCode, T3.[PhotoFile] as RptLabelsPhotoFile, T3.[SAFTProdCategory] as RptLabelsSAFTProdCategory, T3.[Specification] as RptLabelsSpecification, T3.[Thickness] as RptLabelsThickness, T3.[ThicknessMax] as RptLabelsThicknessMax, T3.[ThicknessUM] as RptLabelsThicknessUM, T3.[ACWPercentage] as RptLabelsACWPercentage, T3.[BWSchedStartTime] as RptLabelsBWSchedStartTime, T3.[MinimizeWIP] as RptLabelsMinimizeWIP, T3.[SchedulingDirection] as RptLabelsSchedulingDirection, T3.[SyncReqBy] as RptLabelsSyncReqBy, T3.[TimeZoneAdjustForDST] as RptLabelsTimeZoneAdjustForDST, T3.[TimeZoneID] as RptLabelsTimeZoneID, T3.[MXCustomsUOM] as RptLabelsMXCustomsUOM, T3.[MXSATCode] as RptLabelsMXSATCode, T3.[PECommercialUOM] as RptLabelsPECommercialUOM, T3.[PESUNATCode] as RptLabelsPESUNATCode, T3.[AllowBuildParent] as RptLabelsAllowBuildParent, T3.[EnforcePkgControlRules] as RptLabelsEnforcePkgControlRules, T3.[IsHoldWarehouse] as RptLabelsIsHoldWarehouse, T3.[WarehouseType] as RptLabelsWarehouseType, T3.[WarehouseTypeDefault] as RptLabelsWarehouseTypeDefault, T3.[EpicorAccountNum] as RptLabelsEpicorAccountNum, T3.[Calc_AddressList] as RptLabelsCalc_AddressList, T3.[Calc_AGCompanyAFIPResponsibilityDesc] as RptLabelsCalc_AGCompanyAFIPResponsibilityDesc, T3.[Calc_CalcPSPrice] as RptLabelsCalc_CalcPSPrice, T3.[Calc_CalcPSTaxes] as RptLabelsCalc_CalcPSTaxes, T3.[Calc_DisplayBackOrdQtyHeaderLabel] as RptLabelsCalc_DisplayBackOrdQtyHeaderLabel, T3.[Calc_ExecutionTime] as RptLabelsCalc_ExecutionTime, T3.[Calc_GenerateDigitalSignature] as RptLabelsCalc_GenerateDigitalSignature, T3.[Calc_PlantAddress] as RptLabelsCalc_PlantAddress, T3.[Calc_PrintCompanyName] as RptLabelsCalc_PrintCompanyName, T3.[Calc_UseCopyNumInPackSlips] as RptLabelsCalc_UseCopyNumInPackSlips, T3.[Description] as RptLabelsDescription, T3.[ASNPrintedDate] as RptLabelsASNPrintedDate, T3.[DigitalSignature] as RptLabelsDigitalSignature, T3.[DocCopyNum] as RptLabelsDocCopyNum, T3.[EDIShipToNum] as RptLabelsEDIShipToNum, T3.[FirstPrintDate] as RptLabelsFirstPrintDate, T3.[MXIncoterm] as RptLabelsMXIncoterm, T3.[SignedBy] as RptLabelsSignedBy, T3.[SignedOn] as RptLabelsSignedOn, T3.[Calc_AGAFIPResponsibilityDesc] as RptLabelsCalc_AGAFIPResponsibilityDesc, T3.[Calc_AGShipToResaleID] as RptLabelsCalc_AGShipToResaleID, T3.[Calc_AGShipViaAddress] as RptLabelsCalc_AGShipViaAddress, T3.[Calc_AGShipViaAFIPResponsibilityDesc] as RptLabelsCalc_AGShipViaAFIPResponsibilityDesc, T3.[Calc_BAddr1] as RptLabelsCalc_BAddr1, T3.[Calc_BAddr2] as RptLabelsCalc_BAddr2, T3.[Calc_BAddr3] as RptLabelsCalc_BAddr3, T3.[Calc_BCity] as RptLabelsCalc_BCity, T3.[Calc_BilContct] as RptLabelsCalc_BilContct, T3.[Calc_BillToAddress] as RptLabelsCalc_BillToAddress, T3.[Calc_BName] as RptLabelsCalc_BName, T3.[Calc_BState] as RptLabelsCalc_BState, T3.[Calc_BZipCode] as RptLabelsCalc_BZipCode, T3.[Calc_CarrierDesc] as RptLabelsCalc_CarrierDesc, T3.[Calc_CarrierSCAC] as RptLabelsCalc_CarrierSCAC, T3.[Calc_Contct] as RptLabelsCalc_Contct, T3.[Calc_CurrName] as RptLabelsCalc_CurrName, T3.[Calc_CusPhone] as RptLabelsCalc_CusPhone, T3.[Calc_CustId] as RptLabelsCalc_CustId, T3.[Calc_CustPartOpts] as RptLabelsCalc_CustPartOpts, T3.[Calc_EmailAddress] as RptLabelsCalc_EmailAddress, T3.[Calc_FaxNum] as RptLabelsCalc_FaxNum, T3.[Calc_FOBDescription] as RptLabelsCalc_FOBDescription, T3.[Calc_LegalNum] as RptLabelsCalc_LegalNum, T3.[Calc_NumRecordPerPage] as RptLabelsCalc_NumRecordPerPage, T3.[Calc_NumTotalParts] as RptLabelsCalc_NumTotalParts, T3.[Calc_PhoneNum] as RptLabelsCalc_PhoneNum, T3.[Calc_PoNum] as RptLabelsCalc_PoNum, T3.[Calc_RptUsedID] as RptLabelsCalc_RptUsedID, T3.[Calc_SAddr1] as RptLabelsCalc_SAddr1, T3.[Calc_SAddr2] as RptLabelsCalc_SAddr2, T3.[Calc_SAddr3] as RptLabelsCalc_SAddr3, T3.[Calc_SalesRepName] as RptLabelsCalc_SalesRepName, T3.[Calc_SCity] as RptLabelsCalc_SCity, T3.[Calc_SEmailAddr] as RptLabelsCalc_SEmailAddr, T3.[Calc_ShipToAddress] as RptLabelsCalc_ShipToAddress, T3.[Calc_ShipViaDescription] as RptLabelsCalc_ShipViaDescription, T3.[Calc_ShipViaSCAC] as RptLabelsCalc_ShipViaSCAC, T3.[Calc_SName] as RptLabelsCalc_SName, T3.[Calc_SoldToAddress] as RptLabelsCalc_SoldToAddress, T3.[Calc_SState] as RptLabelsCalc_SState, T3.[Calc_stFax] as RptLabelsCalc_stFax, T3.[Calc_stPhone] as RptLabelsCalc_stPhone, T3.[Calc_SZipCode] as RptLabelsCalc_SZipCode, T3.[Calc_TermsDescription] as RptLabelsCalc_TermsDescription, T3.[Calc_WeightGrossWords] as RptLabelsCalc_WeightGrossWords, T3.[Calc_WeightWords] as RptLabelsCalc_WeightWords, T3.[AGAFIPResponsibilityCode] as RptLabelsAGAFIPResponsibilityCode, T3.[EMailAddress] as RptLabelsEMailAddress, T3.[FaxNum] as RptLabelsFaxNum, T3.[TradingPartnerName] as RptLabelsTradingPartnerName, T3.[UOMSymbol] as RptLabelsUOMSymbol, T3.[WebDesc] as RptLabelsWebDesc, T3.[CustContainerPartNum] as RptLabelsCustContainerPartNum, T3.[DockingStation] as RptLabelsDockingStation, T3.[LabelType] as RptLabelsLabelType, T3.[PkgCodePartNum] as RptLabelsPkgCodePartNum, T3.[RevisionNum] as RptLabelsRevisionNum, T3.[UseShipDtlInfo] as RptLabelsUseShipDtlInfo, T3.[WarrantySendToFSA] as RptLabelsWarrantySendToFSA, T3.[Calc_CommodityCode] as RptLabelsCalc_CommodityCode, T3.[Calc_DocTotalTax] as RptLabelsCalc_DocTotalTax, T3.[Calc_DspBackOrdQty] as RptLabelsCalc_DspBackOrdQty, T3.[Calc_DspBackOrdQtyUom] as RptLabelsCalc_DspBackOrdQtyUom, T3.[Calc_DspBackOrdQtyUom_UOMSymbol] as RptLabelsCalc_DspBackOrdQtyUom_UOMSymbol, T3.[Calc_DspDimQty] as RptLabelsCalc_DspDimQty, T3.[Calc_DspInvShpQty] as RptLabelsCalc_DspInvShpQty, T3.[Calc_DspJobShpQty] as RptLabelsCalc_DspJobShpQty, T3.[Calc_DspLabDur] as RptLabelsCalc_DspLabDur, T3.[Calc_DspLabelNum] as RptLabelsCalc_DspLabelNum, T3.[Calc_DspLabMod] as RptLabelsCalc_DspLabMod, T3.[Calc_DspLineDesc] as RptLabelsCalc_DspLineDesc, T3.[Calc_DspLineShpQty] as RptLabelsCalc_DspLineShpQty, T3.[Calc_DspLineShpQtyUom] as RptLabelsCalc_DspLineShpQtyUom, T3.[Calc_DspLineShpQtyUom_UOMDesc] as RptLabelsCalc_DspLineShpQtyUom_UOMDesc, T3.[Calc_DspLineShpQtyUom_UOMSymbol] as RptLabelsCalc_DspLineShpQtyUom_UOMSymbol, T3.[Calc_DspMatDur] as RptLabelsCalc_DspMatDur, T3.[Calc_DspMatMod] as RptLabelsCalc_DspMatMod, T3.[Calc_DspMiscAmt] as RptLabelsCalc_DspMiscAmt, T3.[Calc_DspMiscCode] as RptLabelsCalc_DspMiscCode, T3.[Calc_DspMiscDesc] as RptLabelsCalc_DspMiscDesc, T3.[Calc_DspMiscDur] as RptLabelsCalc_DspMiscDur, T3.[Calc_DspMiscMod] as RptLabelsCalc_DspMiscMod, T3.[Calc_DspMiscSeq] as RptLabelsCalc_DspMiscSeq, T3.[Calc_DspOrdRelJobShpQty] as RptLabelsCalc_DspOrdRelJobShpQty, T3.[Calc_DspOrdRelStkShpQty] as RptLabelsCalc_DspOrdRelStkShpQty, T3.[Calc_DspPackLine] as RptLabelsCalc_DspPackLine, T3.[Calc_DspPkgCode] as RptLabelsCalc_DspPkgCode, T3.[Calc_DspPkgDesc] as RptLabelsCalc_DspPkgDesc, T3.[Calc_DspPlannedQty] as RptLabelsCalc_DspPlannedQty, T3.[Calc_DspPlannedQtyUom] as RptLabelsCalc_DspPlannedQtyUom, T3.[Calc_DspPlannedQtyUom_UOMSymbol] as RptLabelsCalc_DspPlannedQtyUom_UOMSymbol, T3.[Calc_DspSerialNumber] as RptLabelsCalc_DspSerialNumber, T3.[Calc_DspShipRouting] as RptLabelsCalc_DspShipRouting, T3.[Calc_DspSubShipTo] as RptLabelsCalc_DspSubShipTo, T3.[Calc_DspUnitPrice] as RptLabelsCalc_DspUnitPrice, T3.[Calc_DspWarrDesc] as RptLabelsCalc_DspWarrDesc, T3.[Calc_GetNextLegalNum] as RptLabelsCalc_GetNextLegalNum, T3.[Calc_GrossWeight] as RptLabelsCalc_GrossWeight, T3.[Calc_GrossWeightUOM] as RptLabelsCalc_GrossWeightUOM, T3.[Calc_HidePackLine] as RptLabelsCalc_HidePackLine, T3.[Calc_JobHUDChr1] as RptLabelsCalc_JobHUDChr1, T3.[Calc_JobHUDChr2] as RptLabelsCalc_JobHUDChr2, T3.[Calc_JobHUDChr3] as RptLabelsCalc_JobHUDChr3, T3.[Calc_JobHUDChr4] as RptLabelsCalc_JobHUDChr4, T3.[Calc_JobHUDDat1] as RptLabelsCalc_JobHUDDat1, T3.[Calc_JobHUDDat2] as RptLabelsCalc_JobHUDDat2, T3.[Calc_JobHUDDat3] as RptLabelsCalc_JobHUDDat3, T3.[Calc_JobHUDDat4] as RptLabelsCalc_JobHUDDat4, T3.[Calc_JobHUDDec1] as RptLabelsCalc_JobHUDDec1, T3.[Calc_JobHUDDec2] as RptLabelsCalc_JobHUDDec2, T3.[Calc_JobHUDInt1] as RptLabelsCalc_JobHUDInt1, T3.[Calc_JobHUDInt2] as RptLabelsCalc_JobHUDInt2, T3.[Calc_LegalText] as RptLabelsCalc_LegalText, T3.[Calc_LinChangd] as RptLabelsCalc_LinChangd, T3.[Calc_MarkForAddress] as RptLabelsCalc_MarkForAddress, T3.[Calc_NextLegalNumID] as RptLabelsCalc_NextLegalNumID, T3.[Calc_NumLineByInv] as RptLabelsCalc_NumLineByInv, T3.[Calc_OrdDtlRef] as RptLabelsCalc_OrdDtlRef, T3.[Calc_OrdRelRef] as RptLabelsCalc_OrdRelRef, T3.[Calc_OrdrUDChr1] as RptLabelsCalc_OrdrUDChr1, T3.[Calc_OrdrUDChr2] as RptLabelsCalc_OrdrUDChr2, T3.[Calc_OrdrUDChr3] as RptLabelsCalc_OrdrUDChr3, T3.[Calc_OrdrUDChr4] as RptLabelsCalc_OrdrUDChr4, T3.[Calc_OrdrUDDat1] as RptLabelsCalc_OrdrUDDat1, T3.[Calc_OrdrUDDat2] as RptLabelsCalc_OrdrUDDat2, T3.[Calc_OrdrUDDat3] as RptLabelsCalc_OrdrUDDat3, T3.[Calc_OrdrUDDat4] as RptLabelsCalc_OrdrUDDat4, T3.[Calc_OrdrUDDec1] as RptLabelsCalc_OrdrUDDec1, T3.[Calc_OrdrUDDec2] as RptLabelsCalc_OrdrUDDec2, T3.[Calc_OrdrUDInt1] as RptLabelsCalc_OrdrUDInt1, T3.[Calc_OrdrUDInt2] as RptLabelsCalc_OrdrUDInt2, T3.[Calc_PartUDChr1] as RptLabelsCalc_PartUDChr1, T3.[Calc_PartUDChr2] as RptLabelsCalc_PartUDChr2, T3.[Calc_PartUDChr3] as RptLabelsCalc_PartUDChr3, T3.[Calc_PartUDChr4] as RptLabelsCalc_PartUDChr4, T3.[Calc_PartUDDat1] as RptLabelsCalc_PartUDDat1, T3.[Calc_PartUDDat2] as RptLabelsCalc_PartUDDat2, T3.[Calc_PartUDDat3] as RptLabelsCalc_PartUDDat3, T3.[Calc_PartUDDat4] as RptLabelsCalc_PartUDDat4, T3.[Calc_PartUDDec1] as RptLabelsCalc_PartUDDec1, T3.[Calc_PartUDDec2] as RptLabelsCalc_PartUDDec2, T3.[Calc_PartUDDec3] as RptLabelsCalc_PartUDDec3, T3.[Calc_PartUDDec4] as RptLabelsCalc_PartUDDec4, T3.[Calc_PartUDInt1] as RptLabelsCalc_PartUDInt1, T3.[Calc_PartUDInt2] as RptLabelsCalc_PartUDInt2, T3.[Calc_POLine] as RptLabelsCalc_POLine, T3.[Calc_SerialNumLabl] as RptLabelsCalc_SerialNumLabl, T3.[Calc_ShippedCUMMDate] as RptLabelsCalc_ShippedCUMMDate, T3.[Calc_ShippedCUMMQty] as RptLabelsCalc_ShippedCUMMQty, T3.[Calc_ShippedQtyPack] as RptLabelsCalc_ShippedQtyPack, T3.[Calc_ShippedUomPack] as RptLabelsCalc_ShippedUomPack, T3.[Calc_ShippedUomPack_UOMSymbol] as RptLabelsCalc_ShippedUomPack_UOMSymbol, T3.[Calc_TotalLineCost] as RptLabelsCalc_TotalLineCost, T3.[Calc_TotalTax] as RptLabelsCalc_TotalTax, T3.[ContractDescription] as RptLabelsContractDescription, T3.[DimCodeDescription] as RptLabelsDimCodeDescription, T3.[PartDescription] as RptLabelsPartDescription, T3.[PartLotDescription] as RptLabelsPartLotDescription, T3.[DisplaySeq] as RptLabelsDisplaySeq, T3.[KitAllowUpdate] as RptLabelsKitAllowUpdate, T3.[KitBackFlush] as RptLabelsKitBackFlush, T3.[KitFlag] as RptLabelsKitFlag, T3.[KitParentLine] as RptLabelsKitParentLine, T3.[KitPricing] as RptLabelsKitPricing, T3.[KitPrintCompsInv] as RptLabelsKitPrintCompsInv, T3.[KitPrintCompsPS] as RptLabelsKitPrintCompsPS, T3.[KitQtyPer] as RptLabelsKitQtyPer, T3.[KitShipComplete] as RptLabelsKitShipComplete, T3.[KitsLoaded] as RptLabelsKitsLoaded, T3.[CardMemberName] as RptLabelsCardMemberName, T3.[PONum] as RptLabelsPONum, T3.[MarkForNum] as RptLabelsMarkForNum, T3.[OpenRelease] as RptLabelsOpenRelease, T3.[RAN] as RptLabelsRAN, T3.[MfgComment] as RptLabelsMfgComment, T3.[PurComment] as RptLabelsPurComment, T3.[TrackDimension] as RptLabelsTrackDimension, T3.[TrackLots] as RptLabelsTrackLots, T3.[TrackSerialNum] as RptLabelsTrackSerialNum, T3.[UPCCode1] as RptLabelsUPCCode1, T3.[UPCCode2] as RptLabelsUPCCode2, T3.[UPCCode3] as RptLabelsUPCCode3, T3.[WarrDescription] as RptLabelsWarrDescription, T3.[Expendable] as RptLabelsExpendable, T3.[InternalPromptSetHeight] as RptLabelsInternalPromptSetHeight, T3.[InternalPromptSetLength] as RptLabelsInternalPromptSetLength, T3.[InternalPromptSetWidth] as RptLabelsInternalPromptSetWidth, T3.[PkgInternalHeight] as RptLabelsPkgInternalHeight, T3.[PkgInternalLength] as RptLabelsPkgInternalLength, T3.[PkgInternalWidth] as RptLabelsPkgInternalWidth, T3.[PkgMtlTypeCode] as RptLabelsPkgMtlTypeCode, T3.[DocMiscAmt] as RptLabelsDocMiscAmt, T3.[Calc_CurrDesc] as RptLabelsCalc_CurrDesc, T3.[Calc_CountryDescription] as RptLabelsCalc_CountryDescription, T3.[Calc_CountryISOCode] as RptLabelsCalc_CountryISOCode, T3.[Calc_Company] as RptLabelsCalc_Company, T3.[Calc_LabelNum] as RptLabelsCalc_LabelNum, T3.[CommodityCode] as RptLabelsCommodityCode, T3.[DocEndCustomerPrice] as RptLabelsDocEndCustomerPrice, T3.[DocInAdvanceBillBal] as RptLabelsDocInAdvanceBillBal, T3.[DocMSRP] as RptLabelsDocMSRP, T3.[EndCustomerPrice] as RptLabelsEndCustomerPrice, T3.[InAdvanceBillBal] as RptLabelsInAdvanceBillBal, T3.[MSRP] as RptLabelsMSRP, T3.[PCLinkRemoved] as RptLabelsPCLinkRemoved, T3.[Rpt1EndCustomerPrice] as RptLabelsRpt1EndCustomerPrice, T3.[Rpt1InAdvanceBillBal] as RptLabelsRpt1InAdvanceBillBal, T3.[Rpt1MSRP] as RptLabelsRpt1MSRP, T3.[Rpt2EndCustomerPrice] as RptLabelsRpt2EndCustomerPrice, T3.[Rpt2InAdvanceBillBal] as RptLabelsRpt2InAdvanceBillBal, T3.[Rpt2MSRP] as RptLabelsRpt2MSRP, T3.[Rpt3EndCustomerPrice] as RptLabelsRpt3EndCustomerPrice, T3.[Rpt3InAdvanceBillBal] as RptLabelsRpt3InAdvanceBillBal, T3.[Rpt3MSRP] as RptLabelsRpt3MSRP, T3.[AdditionNum] as RptLabelsAdditionNum, T3.[AssetNum] as RptLabelsAssetNum, T3.[DisposalNum] as RptLabelsDisposalNum, T3.[BankGiroAcctNbr] as RptLabelsBankGiroAcctNbr, T3.[ClearBankExchRate] as RptLabelsClearBankExchRate, T3.[CNSellerAddress] as RptLabelsCNSellerAddress, T3.[CNSellerBankName] as RptLabelsCNSellerBankName, T3.[DefPosPayEFTHeadUID] as RptLabelsDefPosPayEFTHeadUID, T3.[LogoFont] as RptLabelsLogoFont, T3.[LogoImageID] as RptLabelsLogoImageID, T3.[LogoText01] as RptLabelsLogoText01, T3.[LogoText02] as RptLabelsLogoText02, T3.[LogoText03] as RptLabelsLogoText03, T3.[LogoText04] as RptLabelsLogoText04, T3.[LogoText05] as RptLabelsLogoText05, T3.[LogoText06] as RptLabelsLogoText06, T3.[LogoType] as RptLabelsLogoType, T3.[MXSATNameFull] as RptLabelsMXSATNameFull, T3.[MXSATNameShort] as RptLabelsMXSATNameShort, T3.[PositivePayBatchID] as RptLabelsPositivePayBatchID, T3.[PositivePayRemoteID] as RptLabelsPositivePayRemoteID, T3.[SignatureFont] as RptLabelsSignatureFont, T3.[SignatureImageID] as RptLabelsSignatureImageID, T3.[SignatureText01] as RptLabelsSignatureText01, T3.[SignatureText02] as RptLabelsSignatureText02, T3.[SignatureText03] as RptLabelsSignatureText03, T3.[SignatureText04] as RptLabelsSignatureText04, T3.[SignatureText05] as RptLabelsSignatureText05, T3.[SignatureText06] as RptLabelsSignatureText06, T3.[SignatureType] as RptLabelsSignatureType, T3.[MXRFC] as RptLabelsMXRFC, T3.[PartOptionAvailList] as RptLabelsPartOptionAvailList, T3.[PartOptionSelList] as RptLabelsPartOptionSelList, T4.[AllowAsAltRemitToBank], T4.[BankAcctNumber], T4.[BankID], T4.[CorrespAccount], T4.[LegalName], T4.[LocalBIC], T4.[MXRFC], T4.[TransPersonName], T4.[TransPersonName2], T4.[TransPersonName3], T4.[TransPersonName4], T4.[TransPersonName5], T4.[Calc_PackNum], T5.[Address1], T5.[Address2], T5.[Address3], T5.[AutoBankAdjustment], T5.[AutoBankTransferCrossCurr], T5.[AutoBankTransferSameCurr], T5.[AutoCashMovement], T5.[AutoCustBalanceReceipt], T5.[AutoCustBalanceReceiptApplyAll], T5.[AutoInvoicePayment], T5.[AutoMatchStatement], T5.[AutoOnAccountReceipt], T5.[AutoRcgAPRefNum], T5.[AutoRcgAPSupplier], T5.[AutoRcgAPTranDate], T5.[AutoRcgARCustomer], T5.[AutoRcgARRefNum], T5.[AutoRcgARTranDate], T5.[AutoRcgUnknownTran], T5.[AutoRecDocuments], T5.[AutoRetrieve], T5.[AutoReverse], T5.[AutoStatementImport], T5.[BankAcctID], T5.[BankCustNum], T5.[BankGiroAcctNbr], T5.[BankTranfAccountType], T5.[BankType], T5.[CHDTAID], T5.[CheckingAccount], T5.[CHISRPartyID], T5.[City], T5.[ClearBankExchRate], T5.[CNSellerAddress], T5.[CNSellerBankName], T5.[COIsOneTimeBankAcct], T5.[ConsInvPmt], T5.[COOneTimeID], T5.[CountryNum], T5.[CreditorID], T5.[DefPosPayEFTHeadUID], T5.[DocLOCLimit], T5.[EFTHeadUID], T5.[FilterByLine], T5.[FloatAmt], T5.[InvPerCheckStub], T5.[JPBankName], T5.[JPBranchName], T5.[LName], T5.[LogoFont], T5.[LogoImageID], T5.[LogoText01], T5.[LogoText02], T5.[LogoText03], T5.[LogoText04], T5.[LogoText05], T5.[LogoText06], T5.[LogoType], T5.[MatchTolerance], T5.[MsgIDCounter], T5.[MXSATCode], T5.[MXSATNameFull], T5.[MXSATNameShort], T5.[ParamCode], T5.[PayrollCheckingAccount], T5.[PeriodThreshold], T5.[POBankAcctNum], T5.[PositivePayBatchID], T5.[PositivePayRemoteID], T5.[PostalCode], T5.[PRAlignTax], T5.[PreprintedCheckNum], T5.[PRLinePerPRCheck], T5.[PRPreprintedCheckNumber], T5.[RBankNum], T5.[RBranchNum], T5.[RecBalFiscalPeriod], T5.[RecBalFiscalYear], T5.[RecBalFiscalYearSuffix], T5.[ReconcileOtherBalances], T5.[RevalueUseRecBal], T5.[Rpt1LOCLimit], T5.[Rpt2LOCLimit], T5.[Rpt3LOCLimit], T5.[SignatureFont], T5.[SignatureImageID], T5.[SignatureText01], T5.[SignatureText02], T5.[SignatureText03], T5.[SignatureText04], T5.[SignatureText05], T5.[SignatureText06], T5.[SignatureType], T5.[State], T5.[TranTemplateID], T6.[DocMiscAmt], T6.[MiscAmt], T6.[MiscCode], T6.[Percentage], T6.[SeqNum], T6.[Type], T6.[WIIsAutoCreatedMisc], T6.[Calc_CurrDesc], T6.[Calc_PackLine], T6.[MiscCode_Description], T7.[LotNum], T7.[MXImportDate], T7.[MXImportLocation], T7.[TotalQtyAvg], T8.[LabelNum], T8.[Calc_Company], T8.[Calc_LabelNum], T9.[Reference], T10.[ApplyDate], T10.[BillConNum], T10.[BillToInvoiceAddress], T10.[BlockedFinChrg], T10.[BlockedFinChrgReason], T10.[BlockedRemLetters], T10.[BlockedRemLettersReason], T10.[CardID], T10.[CardMemberName], T10.[CardmemberReference], T10.[CardNumber], T10.[CardType], T10.[CCStreetAddr], T10.[CCZip], T10.[ChangeDate], T10.[ChangedBy], T10.[ChangeTime], T10.[CheckRef], T10.[ClosedDate], T10.[CMType], T10.[Consolidated], T10.[CorrectionInv], T10.[CreditMemo], T10.[CurrencyCode], T10.[CurrRateDate], T10.[DebitNote], T10.[DeferredRevenue], T10.[DepGainLoss], T10.[DepositCredit], T10.[DNComments], T10.[DNCustNbr], T10.[DocDepApplied], T10.[DocDepositCredit], T10.[DocInvoiceAmt], T10.[DocInvoiceBal], T10.[DocPayAmounts], T10.[DocPayDiscAmt], T10.[DocRounding], T10.[DocumentPrinted], T10.[DocUnpostedBal], T10.[DocWithholdAmt], T10.[DueDate], T10.[EDIReady], T10.[EntryPerson], T10.[ExchangeRate], T10.[ExpirationMonth], T10.[ExpirationYear], T10.[ExternalID], T10.[FiscalCalendarID], T10.[FiscalPeriod], T10.[FiscalYear], T10.[FiscalYearSuffix], T10.[FOB], T10.[GLPosted], T10.[GroupID], T10.[InPrice], T10.[InvoiceAmt], T10.[InvoiceBal], T10.[InvoiceComment], T10.[InvoiceDate], T10.[InvoiceHeld], T10.[InvoiceNum], T10.[InvoiceRef], T10.[InvoiceSuffix], T10.[InvoiceType], T10.[JournalCode], T10.[JournalNum], T10.[LastChrgCalcDate], T10.[LineType], T10.[LockRate], T10.[LockTaxRate], T10.[OpenInvoice], T10.[PayAmounts], T10.[PayDates], T10.[PayDiscAmt], T10.[PayDiscDate], T10.[PayDiscDays], T10.[PayDiscPartPay], T10.[PayDiscPer], T10.[PIPayment], T10.[Plant], T10.[PMUID], T10.[PONum], T10.[Posted], T10.[ProcessCard], T10.[RateGrpCode], T10.[ReadyToCalc], T10.[RecalcBeforePost], T10.[RefCancelled], T10.[RefCancelledBy], T10.[RepComm1], T10.[RepComm2], T10.[RepComm3], T10.[RepComm4], T10.[RepComm5], T10.[RepRate1], T10.[RepRate2], T10.[RepRate3], T10.[RepRate4], T10.[RepRate5], T10.[RepSales1], T10.[RepSales2], T10.[RepSales3], T10.[RepSales4], T10.[RepSales5], T10.[RepSplit1], T10.[RepSplit2], T10.[RepSplit3], T10.[RepSplit4], T10.[RepSplit5], T10.[RMANum], T10.[Rounding], T10.[Rpt1DepGainLoss], T10.[Rpt1DepositCredit], T10.[Rpt1InvoiceAmt], T10.[Rpt1InvoiceBal], T10.[Rpt1PayAmounts], T10.[Rpt1PayDiscAmt], T10.[Rpt1Rounding], T10.[Rpt1UnpostedBal], T10.[Rpt1WithholdAmt], T10.[Rpt2DepGainLoss], T10.[Rpt2DepositCredit], T10.[Rpt2InvoiceAmt], T10.[Rpt2InvoiceBal], T10.[Rpt2PayAmounts], T10.[Rpt2PayDiscAmt], T10.[Rpt2Rounding], T10.[Rpt2UnpostedBal], T10.[Rpt2WithholdAmt], T10.[Rpt3DepGainLoss], T10.[Rpt3DepositCredit], T10.[Rpt3InvoiceAmt], T10.[Rpt3InvoiceBal], T10.[Rpt3PayAmounts], T10.[Rpt3PayDiscAmt], T10.[Rpt3Rounding], T10.[Rpt3UnpostedBal], T10.[Rpt3WithholdAmt], T10.[SalesRepList], T10.[SEBankRef], T10.[SoldToCustNum], T10.[SoldToInvoiceAddress], T10.[StartUp], T10.[TaxPoint], T10.[TaxRateDate], T10.[TaxRateGrpCode], T10.[TaxRegionCode], T10.[TermsCode], T10.[TotFinChrg], T10.[TranDocTypeID], T10.[UnappliedCash], T10.[UnpostedBal], T10.[UseAltBillTo], T10.[WithholdAmt], T10.[XRefInvoiceNum]
, T11.[DrawNum]
, T1.[ServRef1]
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 CustBank_" + Parameters!TableGuid.Value + " T4 ON T1.[Company] = T4.[Company] AND T1.[PackNum] = T4.[Calc_PackNum]
LEFT OUTER JOIN BankAcct_" + Parameters!TableGuid.Value + " T5 ON T1.[Company] = T5.[Company] AND T1.[PackNum] = T5.[Calc_PackNum]
LEFT OUTER JOIN ShipMisc_" + Parameters!TableGuid.Value + " T6 ON T1.[Company] = T6.[Company] AND T1.[PackNum] = T6.[PackNum]
LEFT OUTER JOIN PartLot_" + Parameters!TableGuid.Value + " T7 ON T2.[Company] = T7.[Company] AND T2.[PackLine] = T7.[Calc_PackLine] AND T2.[PackNum] = T7.[Calc_PackNum]
LEFT OUTER JOIN rptttLabelSeq_" + Parameters!TableGuid.Value + " T8 ON T2.[Company] = T8.[Company] AND T2.[PackNum] = T8.[PackNum] AND T2.[PackLine] = T8.[PackLine]
LEFT OUTER JOIN OrderRel_" + Parameters!TableGuid.Value + " T9 ON T2.[Company] = T9.[Company] AND T2.[OrderNum] = T9.[OrderNum] AND T2.[OrderLine] = T9.[OrderLine] AND T2.[OrderRelNum] = T9.[OrderRelNum]
LEFT OUTER JOIN InvcHeadShip_" + Parameters!TableGuid.Value + " T10 ON T1.[Company] = T10.[Company] AND T1.[PackNum] = T10.[Calc_PackNum]LEFT OUTER JOIN PartRev_" + Parameters!TableGuid.Value + " T11 ON T2.[Company] = T11.[Company] AND T2.[PartNum] = T11.[PartNum] AND T2.[RevisionNum] = T11.[RevisionNum]
"
My question is can I remove all the RTPLiterals from this code? Additionally, I pull this code directly from the report and put it into notepad++ to modify, but when I go to post it back into report builder is where I hit a snag. Only about half of that code makes it back into the window before report builder wont let me put in any more characters.
Ill have to give vs code a try and also see if I cant open the whole report elsewhere. Thanks for the help!
Wow ā¦ thatās 40,000 characters.
And about 1180 fields.
T1 has 148 fields
T2 has 233
T3 has 643
T4 has 26
T5 has 99
T6 has 13
T7 has 8
T8 has 7
T9 has 6
T10 has 159
T11 has 5
Do you really need them all?
Especially all the ones in T5 (BankAcct), like
... T5.[SignatureFont], T5.[SignatureImageID], T5.[SignatureText01], T5.[SignatureText02], T5.[SignatureText03], T5.[SignatureText04], T5.[SignatureText05], T5.[SignatureText06], T5.[SignatureType], ...
I donāt believe so, but Iām going to go over it with the team and see what I can get rid of. I just wanted to see what everyone elses was like compared to ours.
Also, when you go to add a new table to a report how do you add it in? Im trying to get away from sync data set, but I am unsure how else to add tables in.
Well thereās your problem ā¦ 
And if youāve already ruined that report by using Sync Data, maybe you can reduce the field count by excluding a but the needed fields.*
Iām guessing that Sync Data will add every non-excluded field.
Make sure to have a backup of the RDL. And any field used in a table relationship in the RDD cannot be excluded.
after excluding unneeded fields, youād have to do the Sync Dataset again.
I did a quick test of making two copies of the original Packslip report style, and using the Sync Dataset on one.
The query expression of the unsynched copy is 3,199 characters long. The table relations in the query are:
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"
The query expression of the ShipHeadShipDtl dataset of the synched copy is 39,714 characters long. And where the unsynched report had 5 datasets, the synched one has 23.
The table relations in the query are:
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 CustBank_" + Parameters!TableGuid.Value + " T4 ON T1.[Company] = T4.[Company] AND T1.[PackNum] = T4.[Calc_PackNum]
LEFT OUTER JOIN BankAcct_" + Parameters!TableGuid.Value + " T5 ON T1.[Company] = T5.[Company] AND T1.[PackNum] = T5.[Calc_PackNum]
LEFT OUTER JOIN ShipMisc_" + Parameters!TableGuid.Value + " T6 ON T1.[Company] = T6.[Company] AND T1.[PackNum] = T6.[PackNum]
LEFT OUTER JOIN PartLot_" + Parameters!TableGuid.Value + " T7 ON T2.[Company] = T7.[Company] AND T2.[PackLine] = T7.[Calc_PackLine] AND T2.[PackNum] = T7.[Calc_PackNum]
LEFT OUTER JOIN rptttLabelSeq_" + Parameters!TableGuid.Value + " T8 ON T2.[Company] = T8.[Company] AND T2.[PackNum] = T8.[PackNum] AND T2.[PackLine] = T8.[PackLine]
LEFT OUTER JOIN InvcHeadShip_" + Parameters!TableGuid.Value + " T9 ON T1.[Company] = T9.[Company] AND T1.[PackNum] = T9.[Calc_PackNum]"
The unsynced RDL has none of the fields from BankAcct. So I doubt theyāre needed.
As to your question of adding tables to RDL based reports, you have to do thre things (assuming the RDD is already updated)
+" LEFT OUTER JOIN Part_" + Parameters!TableGuid.Value + " T11 "
+" ON T2.Company = T11.Company AND T2.PartNum = T11.PartNum"
Update the Query expressionās SELECT clause, by adding the new fields like:
, T11.ISOrigCountry
Add the fields to the dataset (this isnāt in the query expression)
and
Iām a big advocate of not pulling columns that you donāt need.
I assuming you are not on cloud here, and Iām wondering if you could write a stored procedure with dynamic SQL that received the TableGuid parameter and then returned all the results back. A bit like how we used to write Crystal Reports in Enterprise.
Then all your query would consist of the execution of the stored procedure passing the tableguid.
Iāve never had a need to do this, but your question got me thinking. A bit of a hack I know, butā¦
Thoughts anyone?
Since the Sync Dataset functionality blindly adds all un-excluded columns, the next best option would be to search the RDL file (with text or XML editor), searching to references to columns in the dataset, that arenāt used anywhere else in the report.
For example, the synched version of PackSlip has the field T5.AutoBankAdjustment (where T5 is BankAcct_GUID) in the datasetās <Query> and <Fields> sections. But nowhere else.
Iām going to have to rebuild a lot of these reports to get that field count down, but at least I know how to handle these reports going forward. My next question is how do I go about adding two of the same table to a report data definition? Iāve run into several reports that would benefit from me being able to pull in multiples of the same table, but have failed to do so. The report builder usually throws up an error saying that all tables have to be unique.
You canāt. But if you understand how the reporting system works, you might find a work around.
First off, the RDD doesnāt make a single table of results like a BAQ does. It actually makes individual tables, withe just the records required. Theses are the TableName_GUID tables created in the reports DB.
For example, a BAQ that joins OrderDtl to Part, creates a single table output. But an RDD that does that actually creates separate tables OrderDtl_GUID and Part_GUID. But instead of having all the OrderDtl or Part records, each only includes the records needed to make the relationships required in the RDL
So if you make the RDD make a temp table (the xxx _GUID) with more records than yoy need, you could do the āfilteringā in the RDL.
It really depends on why you need the table added a second time.
There is a good chance that the records that you want from that _GUID table are already in it.
What table do you want to add to which RDD? And what relationships would you have for it?
The idea would be to add JobOper into the priority dispatch again without any relationships and build a subreport out of it.
Unrelated, Iām getting an error with an rdd Iām working on and I believe it stems from my where statement.
WHERE T11.[CubeID] = PrevOpDate and T1.RegionCode = 1"
If I remove one of those two statements then it works just fine. Am I formatting the where wrong?
Is RegionCode possibly a string, and not number?
That would make that line
WHERE T11.[CubeID] = PrevOpDate and T1.RegionCode = '1' "
In this case region code is a number, but prevopdate is a string. I changed it to the following and it worked!
WHERE T11.[CubeID] = āPrevOpDateā and T1.RegionCode = 1 "
Thank you so much, youāve helped a lot!
JobOper is not part of the original PrioDisp RDD. So I assume youāve added it once already.
And that whatever relationships you made between that added table and the original tables, is what limits the records that appear in the JobOper_GUID temp table.
Make an RDL for the sub report with the same Data Source as the main report, and a single Dataset. Make a simple query expression for just one table. Something like:
="SELECT T1.JobNum, T1.AssemblySeq, T1.OprSeq
FROM JobOper_" + Parameters!TableGuid.Value + " T1 "
Add those fields to the datasetās properties.
In the body of the RDL put a tablix tied to dataset you created above. Shows the fields in the tablix.
Now if you run the main report (such that the _GUID tables are created - donāt forget to enable some archive time, like 1 week), you can then use that GUID to test your subreport (run on its own). That would show you all the JobOper records that the RDD thinks you need.