I am trying to add in ProdGrup.PersonID. I added the relationship in the data definition, I’ve added updated the query expression in the ssrs file. When I run the report nothing shows up. Am I missing something here?
=“SELECT T1.InvoiceDate,T7.PersonID,T1.Calc_BillToCustID,T1.Calc_BillToCustName, T2.CustNum,T2.InvoiceLine,T2.InvoiceNum,T2.LineDesc,T2.PartNum,T2.ProdCode,T2.SalesUM,T2.SellingShipQty,T2.Calc_CalcMiscChrg,T2.Calc_CustGroupCode,T2.Calc_CustGroupCodeDesc,T2.Calc_dspExtPrice,T2.Calc_dspJobNum,T2.Calc_dspUnitPrice,T2.Calc_LineBCost,T2.Calc_LineCost,T2.Calc_LineLCost,T2.Calc_LineMargin,T2.Calc_LineMCost,T2.Calc_LineMtlBCost,T2.Calc_LineSCost,T2.Calc_ProdGroupDesc,T2.Calc_SoldToCustID,T2.Calc_SoldToCustName,T2.Calc_AdjExists,T2.Calc_JobClosed, T3.KitFlag,T3.KitPricing
, T1.[AGAuthorizationCode], T1.[AGAuthorizationDate], T1.[AGDocConcept], T1.[AGDocumentLetter], T1.[AGInvoicingPoint], T1.[AGLegalNumber], T1.[AGPrintingControlType], T1.[AGUseGoodDefaultMark], T1.[BillingDate], T1.[BillingNumber], T1.[BranchID], T1.[CHISRCodeLine], T1.[CMReason], T1.[CNConfirmDate], T1.[CNTaxInvoiceType], T1.[CollectionsCust], T1.[Company], T1.[ContractDate], T1.[ContractRef], T1.[CopyLatestInvoice], T1.[CounterARForm], T1.[CreatedOn], T1.[CreditOverride], T1.[CreditOverrideDate], T1.[CreditOverrideUserID], T1.[CustAgentName], T1.[CustAgentTaxRegNo], T1.[CycleCode], T1.[CycleInactive], T1.[Deferred], T1.[DepositAmt], T1.[DepositBalance], T1.[DepUnallocatedAmt], T1.[DigitalSignature], T1.[DocCopyNum], T1.[DocDepositAmt], T1.[DocDepositBalance], T1.[DocDepUnallocatedAmt], T1.[DocMaxValueAmt], T1.[DocPECharges], T1.[DocPECommissions], T1.[DocPEDetTaxAmt], T1.[DocPEDischargeAmt], T1.[DocPEInterest], T1.[DocPENoPayPenalty], T1.[DocRecurBalance], T1.[Duration], T1.[EInvException], T1.[EInvoice], T1.[EInvRefNum], T1.[EInvStatus], T1.[EInvTimestamp], T1.[EInvUpdatedBy], T1.[EndDate], T1.[Excluded], T1.[ExportDocDate], T1.[ExportDocRefNum], T1.[ExportReportNo], T1.[ExportType], T1.[FirstPrintDate], T1.[HDCaseNum], T1.[HeadNum], T1.[HoldInvoice], T1.[INExportProcedure], T1.[INShippingPortCode], T1.[InstanceNum], T1.[INTaxTransactionID], T1.[InvInCollections], T1.[InvoiceNumList], T1.[IsAddedToGTI], T1.[IsRecurring], T1.[LastDate], T1.[MainSite], T1.[MaxValueAmt], T1.[MXAccountNumber], T1.[MXApprovalNum], T1.[MXApprovalYear], T1.[MXCancellationMode], T1.[MXCancelledDate], T1.[MXCBB], T1.[MXCertificate], T1.[MXCertificateSN], T1.[MXCertifiedTimestamp], T1.[MXConfirmationCode], T1.[MXDigitalSeal], T1.[MXDomesticTransfer], T1.[MXExportCertOrigin], T1.[MXExportCertOriginNum], T1.[MXExportConfNum], T1.[MXExportCustDocCode], T1.[MXExportOperationType], T1.[MXExternalCode], T1.[MXFiscalFolio], T1.[MXFolio], T1.[MXIncoterm], T1.[MXInvoiceRelationType], T1.[MXMovingReason], T1.[MXMovingReasonFlag], T1.[MXNumRegIdTrib], T1.[MXOriginalAmount], T1.[MXOriginalDate], T1.[MXOriginalFolio], T1.[MXOriginalSeries], T1.[MXOriginalString], T1.[MXOriginalStringTFD], T1.[MXPaidAs], T1.[MXPartPmt], T1.[MXPaymentName], T1.[MXPaymentNum], T1.[MXPostedTimeStamp], T1.[MXPurchaseType], T1.[MXResidenCountryNum], T1.[MXSATCertificateSN], T1.[MXSATSeal], T1.[MXSerie], T1.[MXTaxRcptType], T1.[MXTaxRegime], T1.[MXTotalPayments], T1.[OrdExchangeRate], T1.[OurSupplierCode], T1.[Overpaid], T1.[OverrideEndDate], T1.[OvrDefTaxDate], T1.[PEAPPayNum], T1.[PEBankNumber], T1.[PEBOEIsMultiGen], T1.[PEBOEPosted], T1.[PEBOEStatus], T1.[PECaption], T1.[PECaptionCode], T1.[PECharges], T1.[PECollectionGroupID], T1.[PECommissions], T1.[PEDebitNote], T1.[PEDebitNoteReasonCode], T1.[PEDetractionTranNum], T1.[PEDetrGoodServiceCode], T1.[PEDetTaxAmt], T1.[PEDetTaxCurrencyCode], T1.[PEDischargeAmt], T1.[PEDischargeDate], T1.[PEGuaranteeAddress1], T1.[PEGuaranteeAddress2], T1.[PEGuaranteeAddress3], T1.[PEGuaranteeCity], T1.[PEGuaranteeCountry], T1.[PEGuaranteeName], T1.[PEGuaranteePhoneNum], T1.[PEGuaranteeState], T1.[PEGuaranteeTaxID], T1.[PEGuaranteeZip], T1.[PEInterest], T1.[PENoPayPenalty], T1.[PEProductCode], T1.[PEReasonCode], T1.[PEReasonDesc], T1.[PERefDocID], T1.[PERefDocumentNumber], T1.[PERefDocumentNumber2], T1.[PERefDocumentNumber3], T1.[PERefDocumentNumber4], T1.[PERefDocumentNumber5], T1.[PERefDocumentType], T1.[PERefDocumentType2], T1.[PERefDocumentType3], T1.[PERefDocumentType4], T1.[PERefDocumentType5], T1.[PESUNATDepAmt], T1.[PESUNATDepDate], T1.[PESUNATDepNum], T1.[PostedRecog], T1.[QuoteNum], T1.[ReadyToBill], T1.[RealEstateNo], T1.[RecurBalance], T1.[RecurringState], T1.[RecurSource], T1.[RevisionDate], T1.[RevisionNum], T1.[Rpt1DepositAmt], T1.[Rpt1DepositBalance], T1.[Rpt1DepUnallocatedAmt], T1.[Rpt1MaxValueAmt], T1.[Rpt1PECharges], T1.[Rpt1PECommissions], T1.[Rpt1PEDischargeAmt], T1.[Rpt1PEInterest], T1.[Rpt1PENoPayPenalty], T1.[Rpt1RecurBalance], T1.[Rpt2DepositAmt], T1.[Rpt2DepositBalance], T1.[Rpt2DepUnallocatedAmt], T1.[Rpt2MaxValueAmt], T1.[Rpt2PECharges], T1.[Rpt2PECommissions], T1.[Rpt2PEDischargeAmt], T1.[Rpt2PEInterest], T1.[Rpt2PENoPayPenalty], T1.[Rpt2RecurBalance], T1.[Rpt3DepositAmt], T1.[Rpt3DepositBalance], T1.[Rpt3DepUnallocatedAmt], T1.[Rpt3MaxValueAmt], T1.[Rpt3PECharges], T1.[Rpt3PECommissions], T1.[Rpt3PEDischargeAmt], T1.[Rpt3PEInterest], T1.[Rpt3PENoPayPenalty], T1.[Rpt3RecurBalance], T1.[ServiceInvoice], T1.[SignedBy], T1.[SignedOn], T1.[SiteCode], T1.[SoldToCustNum], T1.[SummarizationDate], T1.[THIsImmatAdjustment], T1.[TWDeclarePeriod], T1.[TWDeclareYear], T1.[TWGenerationType], T1.[TWGUIExportDocumentName], T1.[TWGUIExportRemarks], T1.[TWGUIExportVerification], T1.[TWGUIGroup], T1.[TWGUIRegNumBuyer], T1.[TWGUIRegNumSeller], T1.[TWPeriodPrefix], T1.[UseAltBillToID], T1.[WithTaxConfirm], T1.[XRefContractDate], T1.[XRefContractNum], T2.[BurUnitCost], T2.[ChargeDefRev], T2.[ChargeReclass], T2.[CommodityCode], T2.[ConsolidateLines], T2.[CustCostCenter], T2.[DEDenomination], T2.[DeferredOnly], T2.[DeferredPercent], T2.[DeferredRev], T2.[DeferredRevAmt], T2.[DefRevEndDate], T2.[DefRevPosted], T2.[DefRevStart], T2.[DEInternationalSecuritiesID], T2.[DEIsInvestment], T2.[DEIsSecurityFinancialDerivative], T2.[DEIsServices], T2.[DEPayStatCode], T2.[DocDeferredRevAmt], T2.[DocDspWithholdAmt], T2.[DocInAdvanceBillCredit], T2.[DockingStation], T2.[DocMXUnitPrice], T2.[DropShipPONum], T2.[DspWithholdAmt], T2.[EntityUseCode], T2.[EpicorFSA], T2.[InAdvanceBillCredit], T2.[LbrUnitCost], T2.[LinkedCurrencyCode], T2.[LinkedInvcUnitPrice], T2.[MtlBurUnitCost], T2.[MtlUnitCost], T2.[MXCustomsDuty], T2.[MXCustomsUMFrom], T2.[MXProdServCode], T2.[MXSellingShipQty], T2.[MXUnitPrice], T2.[MYIndustryCode], T2.[OrderLine], T2.[OrderNum], T2.[OurShipQty], T2.[PartiallyDefer], T2.[PBInvoiceLine], T2.[PEBOEHeadNum], T2.[PhaseID], T2.[QuoteLine], T2.[RACode], T2.[RADtlID], T2.[RAID], T2.[Reclass], T2.[ReclassCodeID], T2.[ReclassComments], T2.[Reclassified], T2.[ReclassReasonCode], T2.[RenewalNbr], T2.[Rpt1DeferredRevAmt], T2.[Rpt1DspWithholdAmt], T2.[Rpt1InAdvanceBillCredit], T2.[Rpt1MXUnitPrice], T2.[Rpt2DeferredRevAmt], T2.[Rpt2DspWithholdAmt], T2.[Rpt2InAdvanceBillCredit], T2.[Rpt2MXUnitPrice], T2.[Rpt3DeferredRevAmt], T2.[Rpt3DspWithholdAmt], T2.[Rpt3InAdvanceBillCredit], T2.[Rpt3MXUnitPrice], T2.[SubUnitCost], T2.[ShortChar08], T2.[Calc_LinePrice], T3.[ContractID], T3.[CreateJob], T3.[DefaultOversPricing], T3.[DiscBreakListCode], T3.[DiscListPrice], T3.[DisplaySeq], T3.[DocEndCustomerPrice], T3.[DocInAdvanceBillBal], T3.[DocMSRP], T3.[DocPromotionalPrice], T3.[DupOnJobCrt], T3.[ECCOrderLine], T3.[ECCOrderNum], T3.[ECCPlant], T3.[ECCQuoteLine], T3.[ECCQuoteNum], T3.[EndCustomerPrice], T3.[GroupSeq], T3.[InAdvanceBillBal], T3.[KitCompOrigPart], T3.[KitCompOrigSeq], T3.[LinkToContract], T3.[LockDisc], T3.[MfgJobType], T3.[MOMsourceEst], T3.[MOMsourceType], T3.[MSRP], T3.[OrderLineStatusCode], T3.[OverrideDiscPriceList], T3.[Overs], T3.[OversUnitPrice], T3.[PCLinkRemoved], T3.[PlanGUID], T3.[PlanUserID], T3.[ProFormaInvComment], T3.[PromotionalPrice], T3.[Rpt1EndCustomerPrice], T3.[Rpt1InAdvanceBillBal], T3.[Rpt1MSRP], T3.[Rpt1PromotionalPrice], T3.[Rpt2EndCustomerPrice], T3.[Rpt2InAdvanceBillBal], T3.[Rpt2MSRP], T3.[Rpt2PromotionalPrice], T3.[Rpt3EndCustomerPrice], T3.[Rpt3InAdvanceBillBal], T3.[Rpt3MSRP], T3.[Rpt3PromotionalPrice], T3.[SmartString], T3.[SmartStringProcessed], T3.[Unders], T3.[UndersPct], T3.[Character01], T3.[Character02], T3.[Character03], T3.[Character04], T3.[Character05], T3.[Character06], T3.[Character07], T3.[Character08], T3.[Character09], T3.[Character10], T3.[CheckBox01], T3.[CheckBox02], T3.[CheckBox03], T3.[CheckBox04], T3.[Number01], T3.[ShortChar01], T3.[ShortChar02], T3.[ShortChar03], T3.[ShortChar04], T3.[ShortChar05], T3.[ShortChar06], T3.[ShortChar07], T4.[AEPLOQType], T4.[AGAFIPResponsibilityCode], T4.[AGBillToProvinceCode], T4.[AGGrossIncomeTaxID], T4.[AGIDDocTypeCode], T4.[AGIDDocumentNumber], T4.[AgingCreditClearDate], T4.[AgingCreditClearUserID], T4.[AgingCreditCode], T4.[AgingCreditHold], T4.[AgingCreditHoldDate], T4.[AgingCreditHoldSource], T4.[AGProvinceCode], T4.[AllowAsAltRemitTo], T4.[AnnualRevenue], T4.[BusinessCust], T4.[COIsOneTimeCust], T4.[Collections], T4.[CollectionsDate], T4.[ConsolidateLinesPerPart], T4.[COOneTimeID], T4.[CSR], T4.[CustID], T4.[CustPricingSchema], T4.[DateCollectionPosted], T4.[DefaultInvoicestyle], T4.[DefaultLOQstyle], T4.[DefaultOrderAcknowledgement], T4.[DefaultPackSlip], T4.[DemandCheckCfgAction], T4.[DemandCheckConfig], T4.[DemandCheckForRunOutPart], T4.[DemandCheckForRunOutPartAction], T4.[DemandSplitSched], T4.[DEOrgType], T4.[DueDateCriteria], T4.[EAddress], T4.[ECCType], T4.[EInvCompanyIDAttr], T4.[EInvEndpointIDAttr], T4.[ERSOrder], T4.[ExternalCRMCustomerID], T4.[ExternalCRMCustomerType], T4.[ExternalCRMLastSync], T4.[ExternalCRMSyncRequired], T4.[FederalID], T4.[GroupCode], T4.[ImporterOfRecord], T4.[INCSTNumber], T4.[Industry], T4.[INGSTComplianceRate], T4.[INPANNumber], T4.[INTaxRegistrationID], T4.[InvcOrderCmpDflt], T4.[LOQBookCaFinishing], T4.[LOQBookCapaper], T4.[LOQBookCaPress], T4.[LOQBookCatPlates], T4.[LOQBookPCFinishing], T4.[LOQBookPCPaper], T4.[LOQBookPCPlates], T4.[LOQBookPCPress], T4.[LOQPrepressStyle], T4.[LOQVariations], T4.[MXCURP], T4.[MXGeneralPublic], T4.[MXMunicipio], T4.[Name], T4.[NumberOfEmployees], T4.[OTSmartString], T4.[OversPct], T4.[Ownership], T4.[ParamCode], T4.[PBTerms], T4.[PEAddressID], T4.[PECollectionAgent], T4.[PEDocumentID], T4.[PEGoodsContributor], T4.[PEIdentityDocType], T4.[PENoAddress], T4.[PENotFound], T4.[PEPerceptionRegime], T4.[PeriodicBilling], T4.[PEWithholdAgent], T4.[Rating], T4.[RegistrationCode], T4.[SEC], T4.[SendToFSA], T4.[SyncToExternalCRM], T4.[TaxEntityType], T4.[THBranchID], T4.[TickerLocation], T4.[TickerSymbol], T4.[TWDeductGUIFormatCode], T4.[TWGUIRegNum], T4.[TWTaxPayerType], T4.[UseBlindShipping], T4.[Variations], T4.[WIApplication], T4.[WICustomer], T4.[WIShippingCosts], T4.[CheckBox06], T4.[CheckBox07], T5.[GlobalCustGrup], T5.[GlobalLock], T5.[GroupDesc], T6.[ICCode]
FROM InvcHead_” + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN InvcDtl_" + Parameters!TableGuid.Value + " T2
ON T1.Company = T2.Company AND T1.InvoiceNum = T2.InvoiceNum
LEFT OUTER JOIN OrderDtl_" + Parameters!TableGuid.Value + " T3
ON T2.Company = T3.Company AND T2.OrderNum = T3.OrderNum AND T2.OrderLine = T3.OrderLine
LEFT OUTER JOIN Customer_" + Parameters!TableGuid.Value + " T4 ON T1.[CustNum] = T4.[CustNum]
LEFT OUTER JOIN CustGrup_" + Parameters!TableGuid.Value + " T5 ON T4.[GroupCode] = T5.[GroupCode]
LEFT OUTER JOIN CustIC_" + Parameters!TableGuid.Value + " T6 ON T1.[Company] = T6.[Company] AND T1.[CustNum] = T6.[CustNum]
LEFT OUTER JOIN ProdGrup_" + Parameters!TableGuid.Value + " T7 ON T3.Company = T7.Company AND T3.[ProdCode] = T7.[ProdCode]
"
