SSRS - Add Field to Report

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

See if the thread below is enough to get you started

If not… the basic SSRS questions already have threads with solutions if you want to try searching.

Perfect, thanks for the info. With the documentation provided in the link, I was able to modify the report definition.