Thank you so much for your help with this! I ended up switching the code to the other dataset. I used this code and it works great!
="SELECT T1.[JCDept2_Description], T1.[JobAsmbl2_AssemblySeq], T1.[JobAsmbl2_PartNum], T1.[Calculated_OpenJobQty], T1.[Calculated_OpenJobTarget], T1.[JobHead_Company], T1.[JobHead_JobNum]
, T2.[Calculated_Status], T2.[JCDept2_Description], T2.[JobAsmbl2_AssemblySeq], T2.[JobAsmbl2_PartNum], T2.[Calculated_MinOp], T2.[Calculated_OpenJobQty], T2.[Calculated_OpenJobValue], T2.[JobHead_Company], T2.[JobHead_Date08], T2.[JobHead_DueDate], T2.[JobHead_JobNum], T2.[JobHead_ReqDueDate], T2.[JobHead_StartDate], T2.[Calculated_Status], T2.[Calculated_MinOp], T2.[Calculated_OpenJobValue], T2.[JobHead_Date08], T2.[JobHead_DueDate], T2.[JobHead_ReqDueDate], T2.[JobHead_StartDate]
, T2.[JobOper4_DueDate], T2.[JobOper4_StartDate], T2.[JobOper5_DueDate], T2.[JobOper5_StartDate], T2.[Calculated_LastOpCompl]
FROM OpenJobTargets_" + Parameters!TableGuid.Value + " AS T1 LEFT JOIN OpenJobValues_" + Parameters!TableGuid.Value + " AS T2 ON T1.[JobHead_Company] = T2.[JobHead_Company] AND T1.[JCDept2_Description] = T2.[JCDept2_Description] AND T1.[JobHead_JobNum] = T2.[JobHead_JobNum]"
A note to those copy/pasting any SQL code like this: The line breaks disappear running some line together. This causes a syntax error. Just make sure you have space between everything that needs a space. Thanks again John!
