Summing and eliminate duplicates in crystal report 8.5
Posted on 2009-04-10
I have a database table that store saledetails from an invoicing program. In that table I have the following fields:
What I'm trying to do is to print a record which will show the amount of item a specific customer has ordered. (ie. customer A has made many purchases and he had ordered item A 3 times with quantity 5 each times, item B 2 times with quantity 3 each time and item C 1 time with quantity 1.)
I want my report to show
so far, whenever i execute the crystal report, it will print the following:
I've used a group by item_code and subtotal field. With subtotal i can get the total quantity for each item, but the report still showed a particular item multiple times and the subtotal fields also showed in the group footer section, which made my report looks messy. Any idea how do i get the report i want experts? Thank you.