jspc
asked on
Consolidating Qty's of same item in Crystal Reports
Hello, I am wondering if it is possible in Crystal Report to automatically consolidate the same product sold on a line item but only increment the qty value?
EG If I sold the following product:
Product Code Quantity
ABC 1
ABC 1
Crystal Reports would display it as:
ABC 2
EG If I sold the following product:
Product Code Quantity
ABC 1
ABC 1
Crystal Reports would display it as:
ABC 2
ASKER
Not sure I understand ...
Here's how to group data in crystal reports
https://www.universalclass.com/articles/computers/how-to-group-data-in-crystal-reports.htm
https://www.universalclass.com/articles/computers/how-to-group-data-in-crystal-reports.htm
ASKER
I don't think that will work as on the invoice form there is qty, unit price, value ex tax, value inc total and total value
ASKER
Decided to leave it
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@mike that's a good idea
In detail just sum the qty into a variable
tot_qty=tot_qty+qty
In footer group, print product code, tot_qty
set tot_qty=0 before next iteration
That should do it!!!