I have the report working now with the below Dataset query, but the CallContextBpmData.Character01 field will not come through no matter what I try.
=" SELECT DISTINCT
T1.Company,
T1.CustID,
T1.CustName,
T1.FirmRelease,
T1.IUM,
T1.JobNum,
T1.OrderHeld,
T1.OrderLine,
T1.OrderNum,
T1.OrderRelNum,
T1.PartDesc,
T1.PartNum,
T1.Qty,
T1.ReqDate as ReqDate,
T1.ShipToName,
T1.ShipToNum,
T1.ShipVia,
T1.StagedQty,
T1.WhseCode,
T2.JobNum as JobProd_JobNum,
T2.ProdQty,
T3.CustNum_AgingCreditHold AS OrderDtl_CustNum_AgingCreditHold,
T3.CustNum_CreditHold AS OrderDtl_CustNum_CreditHold,
T3.MktgCampaignID,
T3.MktgEvntSeq,
T3.NeedByDate,
T3.OrderNum_FOB AS OrderDtl_OrderNum_FOB,
T3.ProdCode,
T3.ShortChar01,
T4.Candidate,
T4.CheckOff4,
T4.DueDate AS JobHead_DueDate,
T4.ProductHeight_c,
T4.ProductLength_c,
T4.ProductOversized_c,
T4.ProductWidth_c,
T4.UserDecimal1,
T4.ScaledWeight_c,
(Select Distinct City
FROM ShipTo_" + Parameters!TableGuid.Value + " As Tmp
WHERE Tmp.Company = T5.Company AND Tmp.ShipToNum = T5.ShipToNum AND Tmp.CustNum = T5.ShipToCustNum ) as City,
(Select Distinct State
FROM ShipTo_" + Parameters!TableGuid.Value + " As Tmp
WHERE Tmp.Company = T5.Company AND Tmp.ShipToNum = T5.ShipToNum AND Tmp.CustNum = T5.ShipToCustNum ) as State,
T6.Character01 AS CCBD_Character01
FROM
OMR50_" + Parameters!TableGuid.Value + " T1
LEFT OUTER JOIN
JobProd_" + Parameters!TableGuid.Value + " T2
ON
T1.Company = T2.Company AND T1.OrderLine = T2.OrderLine AND T1.OrderNum = T2.OrderNum AND T1.OrderRelNum = T2.OrderRelNum
LEFT OUTER JOIN
OrderDtl_" + Parameters!TableGuid.Value + " T3
ON
T1.Company = T3.Company AND T1.OrderLine = T3.OrderLine AND T1.OrderNum = T3.OrderNum
LEFT OUTER JOIN
JobHead_" + Parameters!TableGuid.Value + " T4
ON
T2.Company = T4.Company AND T2.JobNum = T4.JobNum
INNER JOIN
OrderRel_" + Parameters!TableGuid.Value + " T5
ON
T3.Company = T5.Company AND T3.OrderLine = T5.OrderLine AND T3.OrderNum = T5.OrderNum
LEFT OUTER JOIN
CallContextBpmData_" + Parameters!TableGuid.Value + " T6
ON
T6.SysRowID = '00000000-0000-0000-0000-000000000000'
WHERE
NOT T3.ProdCode IN ('BADD', 'CCF', 'EXWR', 'GUAR', 'LFRT', 'MOVE', 'OTH', 'PART', 'PARTENTK', 'RAWM', 'REPR', 'RFKT', 'RTXWARR', 'RTXWARRX', 'SC', 'SHOW', 'SUSP', 'TACM', 'UD', 'WARR', 'WARX') AND
NOT T3.ProdCode LIKE 'CLY-%' AND
NOT T3.ProdCode LIKE 'CQR-%' AND
NOT T1.PartNum LIKE 'RECON-%-INSTALL'
"
Here are screenshots of my screen customization:

Each radio button has a different ID and Data values, but they are all set to the CallContextBpmData.Character01 EpBinding.
I’m pulling my hair out trying to figure out what I’m doing wrong…all while hoping it is just something stupid with Kinetic!