Skip records with missing or null values - Ignore draft records when producing a final report - Filter out zero-quantity line items in an order report