Link to home
Start Free TrialLog in
Avatar of jspc
jspcFlag for Australia

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
Avatar of Partha Mandayam
Partha Mandayam
Flag of India image

Create a group on product code
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!!!
Avatar of jspc

ASKER

Not sure I understand ...
Avatar of jspc

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
Avatar of jspc

ASKER

Decided to leave it
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
@mike that's a good idea