OK… I think this is making more sense now

I’m assuming you added the left outer join in SSRS expression for FSCallHd?

in addition to adding the JobMtl table, your expression will also need a filter by that code ‘LABR’?

BUT… if JobMtl can still return more than one row after all this THEN you’d still need to figure out some kind of a SUM in the statement (and/or Group By).

Keeping in mind I don’t have the same data as you, it’s hard for me to build an example up.

Also, I’m looking at editing the expression for FSCallHd (coped below for ref), there are other ways to skin the cat… maybe adding thru subreport?

FSCallHd - stock expression

="SELECT T1.CallComment,

T1.CallNum,

T1.CallPriority,

T1.SchedDate,

T1.Calc_SchTime,

T1.Calc_ShipToContactName,

T1.Calc_ShipToAddr,

T2.CallComment as FSCallDt_CallComment,

T2.CallLine,CAST( T2.CallQty as float ) as CallQty,

T2.IUM,T2.JobNum,

T2.LabCovered,

T2.LineDesc,

T2.MatCovered,

T2.MiscCovered,

T2.PartNum,

T2.ProjectID,

T2.RevisionNum,

T2.SerialNumber,

T2.XPartNum,

T2.XRevisionNum,

T2.Calc_ContDesc,

T2.Calc_ReasonDesc,

T2.Calc_SerialNumber,

T2.Calc_WarrDesc,

CAST( T3.AssemblySeq as nvarchar ) as AssemblySeq,

T3.CallLine as JobAsmbl_CallLine,

T3.CallNum as JobAsmbl_CallNum,

T3.Company,T3.[Description],

T3.JobNum as JobAsmbl_JobNum,

T3.PartNum as JobAsmbl_PartNum,

T4.MiscCode,CAST( T4.Calc_DocBillMiscAmt as float ) as Calc_DocBillMiscAmt,

T4.MiscCode_Description,

T4.Calc_SCMiscCode,

T4.Calc_SCMiscDescription

FROM FSCallHd_" + Parameters!TableGuid.Value + " T1

LEFT OUTER JOIN

FSCallDt_" + Parameters!TableGuid.Value + " T2

ON T1.Company = T2.Company

AND T1.CallNum = T2.CallNum

LEFT OUTER JOIN JobAsmbl_" + Parameters!TableGuid.Value + " T3

ON T2.Company = T3.Company

AND T2.CallNum = T3.CallNum

AND T2.CallLine = T3.CallLine

LEFT OUTER JOIN FSMisc_" + Parameters!TableGuid.Value + " T4

ON T3.CallLine = T4.CallLine

AND T3.CallNum = T4.CallNum

AND T3.Company = T4.Company

AND T3.AssemblySeq = T4.Calc_AsmSeq"