dynRepOrderItem.itemID, itemName, SKU, unitCost, SUM(quantity) AS quantity, SUM(quantity * unitCost) AS totalSales
dynRepOrderItem, supplyItem
= $criteria.startDate AND orderDate <= $criteria.endDate ]]>
dynRepOrderItem.itemID, itemName,SKU, unitCost
($defaultWhereClause)