You need two tables: BKICMSTR and WORKORD
 
I dont use CR, but this query works on Pervasive Control Center:
 
SELECT  
BKICMSTR.BKIC_PROD_CLASS,  
Sum(WORKORD.MTWO_WIP_AMAT) AS AMAT,  
Sum(WORKORD.MTWO_WIP_AOUTPR) AS AOUTPR,  
Sum(WORKORD.MTWO_WIP_ALABOR) AS ALABOR
FROM WORKORD INNER JOIN BKICMSTR ON WORKORD.MTWO_WIP_CODE = BKICMSTR.BKIC_PROD_CODE
WHERE WORKORD.MTWO_WIP_STATUS = 'R'
GROUP BY BKICMSTR.BKIC_PROD_CLASS
 
 
 
 
Kelloggs

SELECT  
BKICMSTR.BKIC_PROD_CLASS,  
Sum(WORKORD.MTWO_WIP_AMAT) AS AMAT,  
Sum(WORKORD.MTWO_WIP_AOUTPR) AS AOUTPR,  
Sum(WORKORD.MTWO_WIP_ALABOR) AS ALABOR  
FROM WORKORD INNER JOIN BKICMSTR ON WORKORD.MTWO_WIP_CODE = BKICMSTR.BKIC_PROD_CODE  
WHERE WORKORD.MTWO_WIP_STATUS = 'C'  
AND WORKORD.MTWO_WIP_AFIN >= '2006-01-01' AND WORKORD.MTWO_WIP_AFIN <= '2006-12-31'
GROUP BY BKICMSTR.BKIC_PROD_CLASS
 
Note:
I am using the Actual Finish Date
and if you have archived WO you need to run another query using the WORKHORD table
 
 
 

I recommend Learning SQL by Alan Beaulieu,  from O'Reilly Media, Inc.

Thanks for the great information!!