Hi, I try to make report for monthly turn over by user. Salesman 1 : 50 Salesman 2 : 60 ...
Instead I get a list of the amount of each order for every user. Saleman 1 : 10 Saleman 1 : 40 Saleman 2: 20 Saleman 2: 20 Saleman 2: 20 Here is the code of the report : select min(sale_order.id) as id, sale_order.user_id as field0, sum(sale_order.amount_total) as field1 from sale_order where sale_order.date_order >= '2010-06-01' and sale_order.date_order <= '2010-06-30' and sale_order.state <> 'cancel' and sale_order.state <> 'draft' group by sale_order.user_id, sale_order.amount_total What have I done wrong ? ? Thanks for the help.. -------------------- m2f -------------------- -- http://www.openobject.com/forum/viewtopic.php?p=58176#58176 -------------------- m2f -------------------- _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman2/listinfo/tinyerp-users
