hi all,
i am having a problem (one of many lol) i will try my best to explain in detail.
i have to make a sales report (CRXI) with individual product sales totals. now the problem arises when sales reps discount a product to €0.00 so it can be given as free stock.
this is throwing my sales totals out saying they have sold more than they have. i am adding it by quantity because the cash figure is not what is required.
database example:
quantity item rep customer price
3 milk bob 1111 23
6 wine gill 2221 45
3 milk paul 3333 5
1 pen paul 3333 0
i have used the select expert and tried to return values
if(price is not equal to 0)
i have also tried setting it between values and greater than but i get then same result.
any products that had a sale set to zero are not showing up in the grouping on the side. They are grouped by rep then by product description then by item code. When i take out that statement the product reappears in the grouping but the sales total is wrong.
i thought maybe there was a problem with the field so i triedadding another table with a cost field that would also be set to zero and when i try to do anything it just crashes crystal.
i have looked at how i link the tables and they are all linked by the same key which is product code and this is a primary key in two of the tables and just a field in another!
please help!!
sorry for the long post i thought it best to be descriptive, thanks again for any help given.
Katie.
Edited by katie1200 - 25 Jun 2009 at 5:09am