i am using select expert, here's my code
{TRANS.PERIODCODE} >= 200901.00 and
{TRANS.DATE} in {?start date} to {?end date} and
{TRANS.TRTYPE} = {?invoice (i) or credit (c) report} and
{TRANS.COSTPRICE} <> 0.00
i have it grouped by:
sales person,
product description,
product number,
product number.
i use product number twice to get the summary for the quantity total.
but when i use the code above some of the products do not appear in the grouping on the left side of crystal.
basically any products that have a 0 costprice value are gone!
if i use
{TRANS.PERIODCODE} >= 200901.00 and
{TRANS.DATE} in {?start date} to {?end date} and
{TRANS.TRTYPE} = {?invoice (i) or credit (c) report}
all the products appear
im at this for two days this is insane it cant be that hard....
Edited by katie1200 - 25 Jun 2009 at 8:07am