We’ve added some new fields to our part record that I’m trying to pass to our Job Traveler. Currently, I have travelers that have the Part table linked already and some fields from part are currently displaying on the traveler. These were added in 10 and I used the dreaded Sync Dataset button to get them on there.
In Kinetic, the Sync Dataset button is gone (there are good reasons for this, but I miss the functionality). I have added the fields in the RDD and I thought I had added them correctly in SSRS but when I print, the fields are not there. I tried to add one to begin with and it is a decimal value so it should always have some type of value to display, even if only 0.00.
For the moment, I’m only concerned with InnerTubeWall_c I’m assuming if I can get that one working, I should be able to follow the same steps for the others.
RDD:
In the dataset definition of the SSRS report, T12 is the part table. I’ve tried adding T12.[InnerTubeWall_c] and T12.InnerTubeWall_c as InnerTubeWall as well as other combinations. Currently it is:
="SELECT T1.DueDate,T1.IUM,T1.ProdQty,T1.ReqDueDate,T1.StartDate,T1.Calc_MultiJobParts,T1.Calc_OrderQty,T1.Calc_StockQty, T2.AssemblySeq,T2.BomSequence,T2.Company,T2.[Description],T2.DrawNum,T2.IUM as JobAsmbl_IUM,T2.JobNum,T2.OverRunQty,T2.PartNum,T2.PullQty,T2.RequiredQty,T2.RevisionNum,T2.Calc_BCAsmSeq,T2.Calc_BCJobNum,T2.Calc_BCPartNum,T2.Calc_BCRevNum,T2.Calc_comment, T3.CommentText,T3.Instructions,T3.DaysOut,T3.DueDate as JobOper_DueDate,T3.EstProdHours,T3.EstSetHours,T3.Machines,T3.OpCode,T3.OpDesc,T3.OprSeq,T3.PrimaryProdOpDtl,T3.PrimarySetupOpDtl,T3.ProdStandard,T3.RunQty,T3.StartDate as JobOper_StartDate,T3.StdFormat,T3.Calc_BCOpCode,T3.Calc_BCOprSeq,T3.Calc_DispStatus,T3.Calc_OPText,T3.Calc_OPType,T3.Calc_PurPoint,T3.Calc_VendorId,T3.Calc_VendorName,T3.OpCode_OpDesc, T4.CapabilityID,T4.ConcurrentCapacity,T4.DailyProdRate,T4.OpDtlSeq,T4.ProdCrewSize,T4.ResourceGrpID,T4.ResourceID,T4.SetUpCrewSize,T4.SetupOrProd,T4.Calc_BCCapabilityID,T4.Calc_BCResGrpID,T4.Calc_BCResourceID,T4.Calc_CapbltyDesc,T4.Calc_ResDesc,T4.Calc_ResGrpDesc,T4.Calc_SchedResDesc,T4.Calc_SchedResGrpDesc,T4.Calc_SchedResGrpID,T4.Calc_SchedResID, T5.ResourceGrpID as ResourceTimeUsed_ResourceGrpID,T5.ResourceID as ResourceTimeUsed_ResourceID,T5.WhatIf
, T1.[ContractID], T1.[CustID], T1.[CustName], T1.[DaysLate], T1.[EPMExportLevel], T1.[ExternalMES], T1.[GroupSeq], T1.[IsCSRSet], T1.[JobCSR], T1.[JobWorkflowState], T1.[LastChangedBy], T1.[LastChangedOn], T1.[LastExternalMESDate], T1.[LastScheduleDate], T1.[LastScheduleProc], T1.[PCLinkRemoved], T1.[PersonID], T1.[PlanGUID], T1.[PlanUserID], T1.[ProcSuspendedUpdates], T1.[ProjProcessed], T1.[ProjProcessedDate], T1.[QuoteNum], T1.[RoughCut], T1.[SchedPriority], T1.[SyncReqBy], T1.[UnReadyCostProcess], T1.[Cust_Draw_Approve_Date_c], T1.[Cust_Draw_Sent_Date_c], T1.[Customer_Approval_c], T1.[Customer_Drawing_c], T1.[Design_Review_c], T1.[Design_Review_Date_c], T1.[Job_Released_Date_c], T1.[Mfg_Drawing_MOM_Complete_c], T1.[Planner_Date_c], T1.[Calc_BOMSequence], T1.[Calc_custADDR1], T1.[Calc_custADDR2], T1.[Calc_custADDR3], T1.[Calc_custCITY], T1.[Calc_custCountry], T1.[Calc_custID], T1.[Calc_custName], T1.[Calc_custStat], T1.[Calc_custZIP], T1.[Calc_LangID], T1.[Calc_UserName], T1.[Calc_XPartNum], T1.[ExpenseCode_Description], T1.[PartNum_MfgComment], T1.[PartNum_PartDescription], T1.[PartNum_PurComment], T1.[PartNum_TrackDimension], T1.[PartNum_TrackLots], T1.[PartNum_TrackSerialNum], T1.[ProdCode_Description], T1.[ProdTeamID_Description], T1.[ProdTeamID_Name], T1.[ProjectID_Description], T1.[QuoteNum_CurrencyCode], T1.[SchedCode_Description], T2.[AssemblyMatch], T2.[DigitalFileName], T2.[JdfPrepressAction], T2.[JdfStatus], T2.[LinkToContract], T2.[OperationType], T2.[OrigStructTag], T2.[PartPlanInfo], T2.[PrepressJobName], T2.[PressDevice], T2.[ReassignSNAsm], T2.[RemovedFromPlan], T2.[SendToPrePress], T2.[SendToPress], T2.[SendToPressInitiator], T2.[TLAODCCost], T2.[Calc_NewPage], T2.[Calc_ParentDesc], T2.[Calc_ParentNum], 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.[JobNum_PartDescription], T2.[WarehouseCode_Description], T3.[ActualEndDate], T3.[ActualEndHour], T3.[ActualStartDate], T3.[ActualStartHour], T3.[AutoSpcEnable], T3.[AutoSpcPeriod], T3.[AutoSpcSubgroup], T3.[CurrentPkgCode], T3.[EstStdDescription], T3.[EstStdType], T3.[ExpCycTm], T3.[ExpGood], T3.[ExpPctUp], T3.[FSJobStatus], T3.[GeneralPlanInfo], T3.[JDFOpCompleted], T3.[LastPCIDPrinted], T3.[LastPrintedDate], T3.[MaterialColorRating], T3.[MiscInfo1], T3.[MiscInfo2], T3.[MobileOperation], T3.[NonProdLimit], T3.[PartQualEnable], T3.[PctReg], T3.[PrinterID], T3.[ProdUOM], T3.[RequestMove], T3.[ReWork], T3.[SetupMaterial], T3.[SetupURL], T3.[WIQueStartDate], T3.[Calc_BCOperCode], T3.[Calc_OpDesc], T3.[Calc_RPTUSERID], T3.[Calc_scrapQty], T3.[SetupGroup_Description], T3.[VendorNum_Name], T3.[VendorPP_Name], T4.[AutoSystemAdded], T4.[IsPrimaryProd], T4.[IsPrimarySetup], T4.[MobileAllocatedResource], T5.[Calc_RTUResDesc], T5.[Calc_RTUResGrpDesc], T6.[Parent], T6.[RelatedOperation], T6.[WarehouseCode], T6.[Calc_WhseCode], T7.[BackFlush], T7.[BasePartNum], T7.[BaseRequiredQty], T7.[BaseRevisionNum], T7.[BaseUOM], T7.[BorrowedQty], T7.[EstBurUnitCost], T7.[EstLbrUnitCost], T7.[EstMtlUnitCost], T7.[EstSubUnitCost], T7.[FindNum], T7.[IsPOCostingMaintained], T7.[IssuedComplete], T7.[IssuedQty], T7.[LoanedQty], T7.[MfgComment], T7.[MtlSeq], T7.[Ordered], T7.[OrigGroupSeq], T7.[PickError], T7.[PlannedQtyPerUnit], T7.[POCostingDirection], T7.[POCostingFactor], T7.[POCostingUnitVal], T7.[PricingUOM], T7.[ReqDate], T7.[ReqRefDes], T7.[Rpt1BillableUnitPrice], T7.[Rpt1UnitPrice], T7.[Rpt2BillableUnitPrice], T7.[Rpt2UnitPrice], T7.[Rpt3BillableUnitPrice], T7.[Rpt3UnitPrice], T7.[SalvageEstBurUnitCredit], T7.[SalvageEstLbrUnitCredit], T7.[SalvageEstMtlUnitCredit], T7.[SalvageEstSubUnitCredit], T7.[SelectForPicking], T7.[ShowStatusIcon], T7.[StagingBinNum], T7.[StagingLotNum], T7.[StagingWarehouseCode], T7.[Weight], T7.[WeightUOM], T7.[WhseAllocFlag], T7.[WIReqDate], T7.[Calc_BCMtlSeq], T7.[Calc_InventoryQty], T7.[Calc_InventoryUOM], T7.[Calc_MtlFixedQty], T7.[Calc_MtlPartDesc], T7.[MiscCode_Description], T7.[VendorNum_Address1], T7.[VendorNum_Address2], T7.[VendorNum_Address3], T7.[VendorNum_City], T7.[VendorNum_Country], T7.[VendorNum_CurrencyCode], T7.[VendorNum_DefaultFOB], T7.[VendorNum_State], T7.[VendorNum_TermsCode], T7.[VendorNum_VendorID], T7.[VendorNum_ZIP], T7.[VendorPP_Address1], T7.[VendorPP_Address2], T7.[VendorPP_Address3], T7.[VendorPP_City], T7.[VendorPP_Country], T7.[VendorPP_PrimPCon], T7.[VendorPP_State], T7.[VendorPP_Zip], T8.[Approved], T8.[RevDescription], T8.[RevShortDesc], T10.[Name], T11.[PrimeRep], T11.[SalesRepCode]
, T1.[XRefPartNum], T12.[ASMEMtl_c], T12.[BareLeft_c], T12.InnerTubeWall_c as InnerTubeWall, T12.[BareRight_c], T12.[Bend_Clr_c], T12.[Coating_c], T12.[DiaShape_c], T12.[GradeShape_c], T12.[GradeStrip_c], T12.[GradeTubePipe_c], T12.[GrooveDepth_c], T12.[GroovePitch_c], T12.[GrooveWidth_c], T12.[HeightShape_c], T12.[LengthShape_c], T12.[LengthTubePipe_c], T12.[MatConsigned_c], T12.[MatShape_c], T12.[MatStrip_c], T12.[MatTubePipe_c], T12.[NameTubePipe_c], T12.[NominalTubePipe_c], T12.[NumStarts_c], T12.[ODTubePipe_c], T12.[PackagingStrip_c], T12.[PitchPerRev_c], T12.[SpecShape_c], T12.[SpecStrip_c], T12.[SpecTubePipe_c], T12.[TemperShape_c], T12.[TemperStrip_c], T12.[TemperTubePipe_c], T12.[ThicknessShape_c], T12.[ThicknessStrip_c], T12.[TypeShape_c], T12.[WallTubePipe_c], T12.[WallType_c], T12.[WallUnderFin_c], T12.[WallUnderFinType_c], T12.[WidthShape_c], T12.[WidthStrip_c], T13.[OrderLine], T13.[OrderNum], T13.[TargetAssemblySeq], T13.[TargetJobNum], T13.[TargetMtlSeq]
, T12.[AGProductMark], T12.[AGUseGoodMark], T12.[AnalysisCode], T12.[BuyToOrder], T12.[ClassID], T12.[CNSpecification], T12.[CommercialBrand], T12.[CommercialCategory], T12.[CommercialColor], T12.[CommercialSize1], T12.[CommercialSize2], T12.[CommercialStyle], T12.[CommercialSubBrand], T12.[CommercialSubCategory], T12.[CommodityCode], T12.[Condition], T12.[ConsolidatedPurchasing], T12.[Constrained], T12.[CostMethod], T12.[CSFCJ5], T12.[CSFLMW], T12.[DEDenomination], T12.[DefaultDim], T12.[DEInternationalSecuritiesID], T12.[DEIsInvestment], T12.[DEIsSecurityFinancialDerivative], T12.[DEIsServices], T12.[DEPayStatCode], T12.[Diameter], T12.[DiameterInside], T12.[DiameterOutside], T12.[DiameterUM], T12.[DiffPrc2PrchUOM], T12.[DropShip], T12.[DupOnJobCrt], T12.[Durometer], T12.[ECCNNumber], T12.[EDICode], T12.[EngineeringAlert], T12.[EstimateID], T12.[EstimateOrPlan], T12.[ExpLicNumber], T12.[ExpLicType], T12.[ExtConfig], T12.[ExternalCRMLastSync], T12.[ExternalCRMPartID], T12.[ExternalCRMSyncRequired], T12.[FSAssetClassCode], T12.[FSPricePerCode], T12.[FSSalesUnitPrice], T12.[GlobalLock], T12.[GlobalPart], T12.[Gravity], T12.[GrossWeight], T12.[GrossWeightUOM], T12.[HazClass], T12.[HazGvrnmtID], T12.[HazItem], T12.[HazPackInstr], T12.[HazSub], T12.[HazTechName], T12.[HTS], T12.[ImageFileName], T12.[ImageID], T12.[InActive], T12.[INChapterID], T12.[InternalPricePerCode], T12.[InternalUnitPrice], T12.[IsCompliant], T12.[IsConfigured], T12.[IsGiftCard], T12.[ISOrigCountry], T12.[ISRegion], T12.[IsRestricted], T12.[IsSafetyItem], T12.[ISSuppUnitsFactor], T12.[LotAppendDate], T12.[LotBatch], T12.[LotBeforeDt], T12.[LotCureDt], T12.[LotDigits], T12.[LotExpDt], T12.[LotFirmware], T12.[LotHeat], T12.[LotLeadingZeros], T12.[LotMfgBatch], T12.[LotMfgDt], T12.[LotMfgLot], T12.[LotNxtNum], T12.[LotPrefix], T12.[LotSeqID], T12.[LotShelfLife], T12.[LotUseGlobalSeq], T12.[LowLevelCode], T12.[MDPV], T12.[Method], T12.[MobilePart], T12.[MtlAnalysisCode], T12.[MtlBurRate], T12.[NAFTAOrigCountry], T12.[NAFTAPref], T12.[NAFTAProd], T12.[NetVolume], T12.[NetVolumeUOM], T12.[NetWeight], T12.[NetWeightUOM], T12.[NonStock], T12.[OnHold], T12.[OnHoldDate], T12.[OnHoldReasonCode], T12.[OwnershipStatus], T12.[PartDescription], T12.[PartHeight], T12.[PartLength], T12.[PartLengthWidthHeightUM], T12.[PartPhotoExists], T12.[PartSpecificPackingUOM], T12.[PartsPerContainer], T12.[PartWidth], T12.[PDMObjID], T12.[PESUNATType], T12.[PESUNATUOM], T12.[PhantomBOM], T12.[PhotoFile], T12.[PricePerCode], T12.[PricingFactor], T12.[ProdCode], T12.[PUM], T12.[PurchasingFactor], T12.[PurchasingFactorDirection], T12.[PurComment], T12.[QtyBearing], T12.[RCOverThreshold], T12.[RCUnderThreshold], T12.[RcvInspectionReq], T12.[RecDocReq], T12.[RefCategory], T12.[ReturnableContainer], T12.[RevChargeMethod], T12.[RunOut], T12.[SalesUM], T12.[SchedBcode], T12.[SearchWord], T12.[SellingFactor], T12.[SellingFactorDirection], T12.[ShipDocReq], T12.[SNBaseDataType], T12.[SNFormat], T12.[SNLastUsedSeq], T12.[SNMask], T12.[SNMaskExample], T12.[SNMaskPrefix], T12.[SNMaskSuffix], T12.[SNPrefix], T12.[Specification], T12.[SubPart], T12.[SyncToExternalCRM], T12.[TaxCatID], T12.[Thickness], T12.[ThicknessMax], T12.[ThicknessUM], T12.[TrackDimension], T12.[TrackLots], T12.[TrackSerialNum], T12.[TypeCode], T12.[UnitPrice], T12.[UOMClassID], T12.[UPCCode1], T12.[UPCCode2], T12.[UPCCode3], T12.[UseHTSDesc], T12.[UseMaskSeq], T12.[UsePartRev], T12.[UserChar1], T12.[UserChar2], T12.[UserChar3], T12.[UserChar4], T12.[UserDate1], T12.[UserDate2], T12.[UserDate3], T12.[UserDate4], T12.[UserDecimal1], T12.[UserDecimal2], T12.[UserDecimal3], T12.[UserDecimal4], T12.[UserInteger1], T12.[UserInteger2], T12.[WarrantyCode], T12.[WebInStock], T12.[WebPart], T12.[DateCreated_c], T12.[EquipFamily_c], T12.[FinHeight_c], T12.[FinsPerInch_c], T12.[Manufacturer_c], T12.[Mfg_Part_Num_c], T12.[PartGroup_c], T12.[PartSubGroup_c], T12.[PNGeneratorCreated_c], T12.[PrimEquipID_c], T12.[Sup_Part_Num_c], T12.[Supports_c]
, T14.[PONum]
, T12.[Certification_c]
, T1.[PrimaryCustomer_c], T3.[InvoiceReviewed_c], T4.[ExcelPrintBox_c], T7.[BuyIt], T8.[PPAStatus_c], T12.[ExpPartClassID_c], T12.[MaterialVerification_c], T12.[NewBuyerID_c], T12.[NewGenerateSugg_c], T12.[NewLeadTime_c], T12.[NewMaximumQty_c], T12.[NewMaxMfgLotSize_c], T12.[NewMinimumQty_c], T12.[NewMinMfgLotSize_c], T12.[NewMinOrderQty_c], T12.[NewPrimBinNum_c], T12.[NewProcessMRP_c], T12.[NewVendorID_c], T12.[NewVendorNum_c], T12.[NOMFinOD_c], T12.[RootDia_c], T12.[SupportDia_c], T12.[SupportQty_c], T12.[SupportWidth_c], T12.[TechBudgetClass_c]
, T15.[PrimBin]
, T1.[Requestor_c]
, T1.[AccelWriteOff_c], T1.[BookLife_c], T1.[DepAdj_c], T1.[DisposeDate_c], T1.[InUseDate_c], T1.[JobStatus_c], T1.[MaintJobCat_c], T1.[MaintJobPartID_c], T1.[MaintPartQty_c], T1.[PrimaryCustomerName_c], T1.[PriorAdditCost_c], T1.[ProdJob_c], T1.[TaxLife_c], T3.[PartDesc_c], T3.[PartID_c], T3.[PartQuantity_c], T7.[MaterialValidated_c], T12.[AppNonStock_c], T12.[BypassBPMs_c], T12.[CustID_c], T12.[PressTestReqd_c], T12.[ReviseChildren_c]
, T1.[CustomerNotified_c], T1.[Dashboard_c], T1.[FileDate_c], T1.[FixedAsset_c], T1.[Notes_c], T1.[NotQuality_c], T1.[OriginalClosingDate_c], T1.[ToolingReqd_c], T1.[UpdatedShipDate_c], T3.[Priority_c], T12.[AccComm_c], T12.[ActiveSub_c], T12.[CreatedBy_c], T12.[DetailReqd_c], T12.[ExpDate_c], T12.[InActiveSub_c], T12.[LotSize_c], T12.[RenCode_c], T12.[SDSOnFile_c], T12.[SDSRequired_c], T12.[SubCost_c], T12.[SubCount_c], T12.[SubLength_c], T12.[Suppliers_c], T12.[Updated_c], T12.[WriteOff_c]
, T1.[AccNotes_c], T1.[IntlShipment_c], T1.[Results_c], T7.[Boxing_c], T12.[PrepaidExpense_c]
FROM JobHead_" + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN JobAsmbl_" + Parameters!TableGuid.Value + " T2
ON T1.Company = T2.Company AND T1.JobNum = T2.JobNum
LEFT OUTER JOIN JobOper_" + Parameters!TableGuid.Value + " T3
ON T2.Company = T3.Company AND T2.JobNum = T3.JobNum AND T2.AssemblySeq = T3.AssemblySeq
LEFT OUTER JOIN JobOpDtl_" + Parameters!TableGuid.Value + " T4
ON T3.Company = T4.Company AND T3.JobNum = T4.JobNum AND T3.AssemblySeq = T4.AssemblySeq AND T3.OprSeq = T4.OprSeq
LEFT OUTER JOIN ResourceTimeUsed_" + Parameters!TableGuid.Value + " T5
ON T4.Company = T5.Company AND T4.JobNum = T5.JobNum AND T4.AssemblySeq = T5.AssemblySeq AND T4.OprSeq = T5.OprSeq AND T4.OpDtlSeq = T5.OpDtlSeq
LEFT OUTER JOIN SubAsmbl_" + Parameters!TableGuid.Value + " T6 ON T2.[Company] = T6.[Company] AND T2.[JobNum] = T6.[JobNum] AND T2.[AssemblySeq] = T6.[Parent]
LEFT OUTER JOIN JobMtl_" + Parameters!TableGuid.Value + " T7 ON T1.[Company] = T7.[Company] AND T1.[JobNum] = T7.[JobNum]
LEFT OUTER JOIN PartRev_" + Parameters!TableGuid.Value + " T8 ON T7.[Company] = T8.[Company] AND T7.[PartNum] = T8.[PartNum]
LEFT OUTER JOIN TTJobPartMtl_" + Parameters!TableGuid.Value + " T9 ON T7.[Company] = T9.[Company] AND T7.[JobNum] = T9.[JobNum] AND T7.[MtlSeq] = T9.[MtlSeq]
LEFT OUTER JOIN Person_" + Parameters!TableGuid.Value + " T10 ON T1.[Company] = T10.[Company] AND T1.[PersonID] = T10.[PersonID]
LEFT OUTER JOIN QSalesRP_" + Parameters!TableGuid.Value + " T11 ON T1.[Company] = T11.[Company] AND T1.[QuoteNum] = T11.[QuoteNum]
LEFT OUTER JOIN Part_" + Parameters!TableGuid.Value + " T12 ON T7.[Company] = T12.[Company] AND T7.[PartNum] = T12.[PartNum]
LEFT OUTER JOIN JobProd_" + Parameters!TableGuid.Value + " T13 ON T1.[Company] = T13.[Company] AND T1.[JobNum] = T13.[JobNum]
LEFT OUTER JOIN OrderHed_" + Parameters!TableGuid.Value + " T14 ON T13.[Company] = T14.[Company] AND T13.[OrderNum] = T14.[OrderNum]
LEFT OUTER JOIN PlantWhse_" + Parameters!TableGuid.Value + " T15 ON T1.[Company] = T15.[Company] AND T1.[PartNum] = T15.[PartNum]
"
and I have added the field in the report:
I then added the field onto the report itself:
=First(Fields!InnerTubeWall.Value, “JobHead”)
But when I print, I don’t get 0.00 or anything at all. Am I missing something or can someone point me in the direction of something that can lead me step by step through the process so I can see what it is I might be missing.
