Hello,
I’m new to Epicor but I am familiar with SSRS. I’m trying to update an SSRS report (QuotForm) to add the field OrderDtl.OrderQty to the dataset called Quote.
The report in question has a number of datasets including the RptLabels dataset. The Quote query which I’ve posted below is already referencing the QuoteDtl table so I thought it would be simple to add the OrderQty field, unfortunately when I do so, SSRS complains that the OrderQty field is an invalid column.
Is there any documentation to properly add a field to a RptLabels report? NoteL the query in the Quote dataset was encapsulated in an expression rather than straight SQL.
Thanks.
SELECT T1.DateQuoted,
T1.ExpirationDate,
T1.QuoteComment,
T1.QuoteNum,
T1.Reference,
T1.Calc_CompanyAddr,
T1.Calc_CompFax,
T1.Calc_CompPhone,
T1.Calc_CurSymbol,
T1.Calc_CustContact,
T1.Calc_CustContactEMail,
T1.Calc_CustFax,
T1.Calc_CustPartOpts,
T1.Calc_CustPhone,
T1.Calc_EMail,
T1.Calc_Message1,
T1.Calc_Message2,
T1.Calc_QuoteAddr,
T1.Currency_CurrDesc,
T1.Customer_Name,
T1.Calc_HasHeadMisc,
T1.DocTax,
T1.UseOTS,
T1.OTSName,
T1.OTSCountryNum_Description,
T1.OTSState,
T1.OTSZip,
T1.OTSAddress1,
T1.OTSAddress2,
T1.OTSAddress3,
T1.ShipTo_Name,
T1.ShipTo_Country,
T1.ShipTo_State,
T1.ShipTo_Zip,
T1.ShipTo_Address1,
T1.ShipTo_Address2,
T1.ShipTo_Address3,
T1.DocTotalPotential,
T1.TotalWeight_c,
T1.TotalWeightUOM_c,
T2.Company,
T2.DiscountPercent,
T2.DocDiscount,
T2.DisplaySeq,
T2.DrawNum,
T2.KitParentLine,
T2.KitFlag,
T2.KitPricing,
T2.KitPrintCompsInv,
T2.KitShipComplete,
T2.LeadTime,
T2.PartNum,
T2.QuoteComment as QuoteDtl_QuoteComment,
T2.QuoteLine,
T2.QuoteNum as QuoteDtl_QuoteNum,
T2.RevisionNum,
T2.XPartNum,
T2.XRevisionNum,
T2.Calc_LineDesc,
T2.Calc_HasMisc,
T2.Calc_Duration,
T2.Calc_Modifier,
T2.Calc_Mate,
T2.Calc_Labor,
T2.Calc_Misc,
T2.ContractNum,
T2.RenewalNbr,
T2.PartNum_Netweight,
T2.PartNum_NetweightUOM,
T2.LineWeight_c,
T2.LineWeightUOM_c,
T2.OrderQty,
T3.DocUnitPrice,
T3.PricePerCode,
T3.QtyNum,T3.SalesUM,
T3.SellingQuantity,
T3.UnitPrice,
T3.Calc_NetPrice,
T3.Calc_UMDescription,
T4.TaxAmt,
T5.TaxCode,
T5.[Percent],
T5.DocTaxAmt
FROM QuoteHed_" + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN QuoteDtl_" + Parameters!TableGuid.Value + " T2
ON T1.Company = T2.Company AND T1.QuoteNum = T2.QuoteNum
LEFT OUTER JOIN QuoteQty_" + Parameters!TableGuid.Value + " T3
ON T2.Company = T3.Company AND T2.QuoteNum = T3.QuoteNum AND T2.QuoteLine = T3.QuoteLine
LEFT OUTER JOIN QuoteDtlTax_" + Parameters!TableGuid.Value + " T4
ON T2.Company = T4.Company AND T2.QuoteNum = T4.QuoteNum AND T2.QuoteLine = T4.QuoteLine
LEFT OUTER JOIN QuoteHedTax_" + Parameters!TableGuid.Value + " T5
ON T1.Company = T5.Company AND T1.QuoteNum = T5.QuoteNum