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"