I'm running into a problem with the product label report. I can't get it to filter by batch.

The product data has a column I could set up as a workorder relation (LinkIDWorkOrder) but there's no batch column (LinkIDWorkOrderBatch).

Right now, I have the relation for OptimizationResults and WorkOrderBatches so I can spit out the name of the batch on the report.. but I just don't see how to filter out the products that don't have any optimized parts in the selected batch.

Anyone with clever ideas?