We have an report style called CashPro Import. This have some info but they want to add the address for the customer. Problem is, every time I add it in I get an error telling me to trace down the error.
Here is the original:
=“SELECT T1.BankAcctID,T1.Company,T1.[Description],T1.Calc_BaseCurrencySymbol,T1.Calc_CurrencyCount, T2.BankAcctID as CheckHed_BankAcctID,T2.CheckAmt,T2.CheckDate,T2.CheckNum,T2.Company as CheckHed_Company,T2.CurrencyCode,T2.DocCheckAmt,T2.HeadNum,T2.ManualPrint,T2.Name,T2.VendorNum,T2.Voided,T2.Calc_DocCheckAmt,T2.Calc_VendorID,T2.Calc_VoidManualCheck,T2.Calc_VendorCurrency,T2.CurrencyCode_CurrDesc,T2.CurrencyCode_CurrencyID,T2.CurrencyCode_CurrName,T2.CurrencyCode_CurrSymbol,CAST( T2.CurrencyCode_DecimalsGeneral as nvarchar ) as CurrencyCode_DecimalsGeneral,T2.CurrencyCode_DocumentDesc,T2.Calc_DspBankCheckAmt
FROM BankAcct_” + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN CheckHed_" + Parameters!TableGuid.Value + " T2
ON T1.Company = T2.Company AND T1.BankAcctID = T2.BankAcctID"
I was thinking I just needed to add in T2.Address1, T2.Address2, etc. But that errors out. Ideas on what I am missing here?