Crystal Color Format Logic


We currently print a barcode (on header level) on our picking sheets, I am trying to insert a formula into the report to fill in the background color yellow if any line items on the report contain a value greater than 0 in "UDF_QTY_PULLED" field on the line level.  One caveat, is I only want to look at regular items, ItemType =1.  I thought it could be a simple code but I think I need to look at all the lines.  Any itemtypes <> 1 I have a script populating the UDF_QTY_PULLED with the orderqty, so all those items will always have a qty in that field.  That is the reasoning to try to filter those out.

IF {SO_PickingSheetWrk.ItemType}="1" and {SO_PickingSheetWrk.UDF_QTY_PULLED}<>0 then crYellow else crNoColor