Are there any methods for determining who changed a report ?
RDD? Report Style? SSRS? BAQ? which part of the report 
I dunno, asking for a friend lol.
Hereâs the deets -
Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: System.Web.Services.Protocols.SoapException: The Hidden expression for the tablix âTable1â contains an error: The expression references the field âCurrencyCode_ReportCurrPosâ, which does not exist in the Fields collection. Expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope. Letters in the names of fields must use the correct case. â> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Hidden expression for the tablix âTable1â contains an error:
Current Report for E10LIVEDB
=âSELECT T1.CurrencyCode,T1.[Description],CAST( T1.CurrencyCode_DecimalsGeneral as nvarchar ) as CurrencyCode_DecimalsGeneral,CAST( T1.CurrencyCode_ReportCurrPos as nvarchar ) as CurrencyCode_ReportCurrPos,T1.CurrencyCode_CurrDesc,T2.Calc_BookExRate BookExRate,T2.BookID,T2.Company,T2.Calc_GroupID, T3.BankAcctID,T3.CheckNum,T3.CurrencyCode as CheckHed_CurrencyCode,T3.HeadNum,T3.ElecPayment,T3.Name,T3.VendorBankAcctNumber,T3.VendorBankIBANCode,T3.VendorBankSwiftNum,T3.VendorNum_VendorID,T3.BankAcctID_Description,T3.ExchangeRate,T3.BankTotalAmt,T3.PaymentTotal,T3.Rpt1PaymentTotal,T3.Rpt2PaymentTotal,T3.Rpt3PaymentTotal,T3.Calc_BankCurrency,T4.DocDiscAmt,T4.GainLossType,T4.DocWithholdAmt,T4.DocTranAmt,T4.Rpt1TranAmt,T4.Rpt1DiscAmt,T4.Rpt1WithholdAmt,T4.Rpt2TranAmt,T4.Rpt2DiscAmt,T4.Rpt2WithholdAmt,T4.Rpt3TranAmt,T4.Rpt3DiscAmt,T4.Rpt3WithholdAmt,T4.TranAmt,T4.DiscAmt,T4.InvoiceNum,T4.Calc_DspDate,T4.WithholdAmt,T5.FiscalPer,T5.FiscalYear,T5.TotalAmount as FiscalTotalAmount,T5.FiscalPeriod,T5.FiscalPeriod,T5.Calc_Rpt1TotalAmount,T5.Calc_Rpt2TotalAmount,T5.Calc_Rpt3TotalAmount
FROM GLBook_â + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN RvJrnTr_" + Parameters!TableGuid.Value + " T2
ON T1.Company = T2.Company AND T1.BookID = T2.BookID
LEFT OUTER JOIN CheckHed_" + Parameters!TableGuid.Value + " T3
ON T2.Company = T3.Company AND T2.Calc_GroupID = T3.GroupID AND T2.Calc_CheckNum = T3.HeadNum
LEFT OUTER JOIN APTran_" + Parameters!TableGuid.Value + " T4
ON T3.Company = T4.Company AND T3.HeadNum = T4.HeadNum
LEFT OUTER JOIN FiscalSum_" + Parameters!TableGuid.Value + " T5
ON T4.Company = T5.Company AND T3.FiscalPeriod = T5.FiscalPer AND T3.FiscalYear = T5.FiscalYear"
Current Standard report that comes with E10:
=âSELECT T1.CurrencyCode,T1.[Description],T1.CurrencyCode_DecimalsGeneral,T1.CurrencyCode_ReportCurrPos,T1.CurrencyCode_CurrDesc,T2.Calc_BookExRate BookExRate,T2.BookID,T2.Company,T2.Calc_GroupID, T3.BankAcctID,T3.CheckNum,T3.CurrencyCode as CheckHed_CurrencyCode,T3.HeadNum,T3.ElecPayment,T3.Name,T3.VendorBankAcctNumber,T3.VendorBankIBANCode,T3.VendorBankSwiftNum,T3.VendorNum_VendorID,T3.BankAcctID_Description,T3.ExchangeRate,T3.BankTotalAmt,T3.PaymentTotal,T3.Rpt1PaymentTotal,T3.Rpt2PaymentTotal,T3.Rpt3PaymentTotal,T3.Calc_BankCurrency,T4.DocDiscAmt,T4.GainLossType,T4.DocWithholdAmt,T4.DocTranAmt,T4.Rpt1TranAmt,T4.Rpt1DiscAmt,T4.Rpt1WithholdAmt,T4.Rpt2TranAmt,T4.Rpt2DiscAmt,T4.Rpt2WithholdAmt,T4.Rpt3TranAmt,T4.Rpt3DiscAmt,T4.Rpt3WithholdAmt,T4.TranAmt,T4.DiscAmt,T4.InvoiceNum,T4.Calc_DspDate,T4.WithholdAmt,T5.FiscalPer,T5.FiscalYear,T5.TotalAmount as FiscalTotalAmount,T5.FiscalPeriod,T5.FiscalPeriod,T5.Calc_Rpt1TotalAmount,T5.Calc_Rpt2TotalAmount,T5.Calc_Rpt3TotalAmount
FROM GLBook_â + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN RvJrnTr_" + Parameters!TableGuid.Value + " T2
ON T1.Company = T2.Company AND T1.BookID = T2.BookID
LEFT OUTER JOIN CheckHed_" + Parameters!TableGuid.Value + " T3
ON T2.Company = T3.Company AND T2.Calc_GroupID = T3.GroupID AND T2.Calc_CheckNum = T3.HeadNum
LEFT OUTER JOIN APTran_" + Parameters!TableGuid.Value + " T4
ON T3.Company = T4.Company AND T3.HeadNum = T4.HeadNum
LEFT OUTER JOIN FiscalSum_" + Parameters!TableGuid.Value + " T5
ON T4.Company = T5.Company AND T3.FiscalPeriod = T5.FiscalPer AND T3.FiscalYear = T5.FiscalYear"
??
3 Likes
1 Like
LMAO! I guess the other option is tying them to chair and throwing them in the river to see if they float 
And for the musiciansâŚ
1 Like
BTW, nobody changed your report. This is an error that many of us have had and it will just go away. Search for the above and you will see others that have had it too. Epicor applied a patch to our SSRS service but it still happensâŚbut only at month end and we really need the reports. 
I know that @pmarques had this issue but there are others too.
Mark W.
1 Like