Nothing currently exists.  Would you want by Vendor, Part or what?

There ya  go!!!
 
SELECT  
BKAP_PO_VNDCOD,  
BKAP_POL_PONM,  
BKAP_POL_CNTR,  
BKAP_POL_PCODE,  
BKAP_POL_ERD,  
BKAP_POL_ARD,  
(BKAP_POL_ARD - BKAP_POL_ERD) AS DF,  
IF((BKAP_POL_ARD - BKAP_POL_ERD)<0,1,0) AS EA,  
IF((BKAP_POL_ARD - BKAP_POL_ERD)=0,1,0) AS OT,  
IF((BKAP_POL_ARD - BKAP_POL_ERD)>0,1,0) AS LA  
FROM BKAPHPO INNER JOIN BKAPHPOL ON BKAPHPO.BKAP_PO_NUM = BKAPHPOL.BKAP_POL_PONM WHERE  
ASCII(LTrim(BKAP_POL_PCODE)) <> 0  
AND BKAP_POL_ARD >= '2011-01-01'  
AND BKAP_POL_ARD <= '2011-12-31'
 
EA = Early
OT = On Time
LA = Late
 
Group them, add the Vendor's Name, some percentages,  and you sir have a report
 
 
 
Kelloggs