Crystal Select Expert not selecting expected records

[NBVC]

I am trying to develop a Crystal Report and have use the Select Expert to create formulas that ultimately produced this SQL statement:

 SELECT "REQUIREMENT"."WORKORDER_BASE_ID", "REQUIREMENT"."WORKORDER_LOT_ID", "REQUIREMENT"."WORKORDER_SUB_ID", "REQUIREMENT"."PIECE_NO", "REQUIREMENT"."CALC_QTY", "REQUIREMENT"."ISSUED_QTY", "REQUIREMENT"."PART_ID", "CUST_ORDER_LINE"."LAST_SHIPPED_DATE", "CUST_ORDER_LINE"."TOTAL_SHIPPED_QTY"
 FROM   "SYSADM"."DEMAND_SUPPLY_LINK" "DEMAND_SUPPLY_LINK", "SYSADM"."REQUIREMENT" "REQUIREMENT", "SYSADM"."CUST_ORDER_LINE" "CUST_ORDER_LINE"
 WHERE  (("DEMAND_SUPPLY_LINK"."SUPPLY_BASE_ID"="REQUIREMENT"."WORKORDER_BASE_ID") AND ("DEMAND_SUPPLY_LINK"."SUPPLY_LOT_ID"="REQUIREMENT"."WORKORDER_LOT_ID")) AND (("DEMAND_SUPPLY_LINK"."DEMAND_BASE_ID"="CUST_ORDER_LINE"."CUST_ORDER_ID") AND ("DEMAND_SUPPLY_LINK"."DEMAND_SEQ_NO"="CUST_ORDER_LINE"."LINE_NO")) AND ("REQUIREMENT"."WORKORDER_BASE_ID" LIKE 'F%' AND "REQUIREMENT"."PART_ID"='91841' AND "CUST_ORDER_LINE"."LAST_SHIPPED_DATE">={ts '2007-10-31 00:00:01'} OR "REQUIREMENT"."WORKORDER_BASE_ID" LIKE 'F%' AND "REQUIREMENT"."PART_ID"='91841' AND "CUST_ORDER_LINE"."TOTAL_SHIPPED_QTY"=0)

It doesn't pull all the data I expect it to and can't figure out why.

When I use the same/similar SQL statement in MS Query (Excel).. I get the expected results.

This is the SQL from Excel's MSQuery:

SELECT REQUIREMENT.WORKORDER_BASE_ID, REQUIREMENT.WORKORDER_LOT_ID, REQUIREMENT.WORKORDER_SUB_ID, REQUIREMENT.PIECE_NO, REQUIREMENT.CALC_QTY, REQUIREMENT.ISSUED_QTY, CUST_ORDER_LINE.CUSTOMER_PART_ID
FROM SYSADM.CUST_ORDER_LINE CUST_ORDER_LINE, SYSADM.DEMAND_SUPPLY_LINK DEMAND_SUPPLY_LINK, SYSADM.REQUIREMENT REQUIREMENT
WHERE REQUIREMENT.WORKORDER_BASE_ID = DEMAND_SUPPLY_LINK.SUPPLY_BASE_ID AND REQUIREMENT.WORKORDER_LOT_ID = DEMAND_SUPPLY_LINK.SUPPLY_LOT_ID AND DEMAND_SUPPLY_LINK.DEMAND_BASE_ID = CUST_ORDER_LINE.CUST_ORDER_ID AND DEMAND_SUPPLY_LINK.DEMAND_SEQ_NO = CUST_ORDER_LINE.LINE_NO AND ((REQUIREMENT.WORKORDER_BASE_ID Like 'F%') AND (REQUIREMENT.PART_ID='91841') AND (CUST_ORDER_LINE.LAST_SHIPPED_DATE>{ts '2007-10-31 00:00:00'}) OR (REQUIREMENT.WORKORDER_BASE_ID Like 'F%') AND (REQUIREMENT.PART_ID='91841') AND (CUST_ORDER_LINE.TOTAL_SHIPPED_QTY=0))

I don't really see the difference... Does anyone know what is happening?

Thanks.

 

[NBVC]

....bump.....


FYI, I just crossposted this question here... http://www.crystalreportsbook.com/Forum/forum_posts.asp?TID=3044&PID=9602#9602

hoping to get a suggestion for a solution....