Crystal Reports XI - formula to remove duplicate records
Posted on 2010-11-29
can someone please help me to create this formula in order to remove duplicate records.
I have Part Number, Formula A and Formula B.
Formula A states:
if Code='A' then show value from VALUE field
Formula B states:
if Code='B' then show value from VALUE field
Both of these formulas as in my report details
so the output will create 2 records to each part.
line 1: |Part 123| Coke| 'blank'|
line 2: |Part 123| 'blank'| 'Cisco'|
how can I combine these 2 lines so that it will show only data like this:
line 1: |Part 123| Coke| Cisco|