Delete - Remove Duplicates

[bstafford21]

Using Crystal 9 in conjunction with Magic eDeveloper 9.3 Pervasive database.


I have the following in my Crystal 9 Report

GROUPHEADER 1
COMPONENTS.COMPONENTS PART No

DETAILS
(1)SO_Items.Due Date (2)SO_Items.SO No (3)WO.WO No.
(4)Part.Part No. (5)SO_Items.Qty (6)COMPONENTS.Qty Var
(7)@Material Qty ={SO_Items.Qty}*{COMPONENTS.Qty Var}

GROUP FOOTER
Stock.Qty on Hand (This shows the total that is now correct)


Example Detail Fields:
Due Date SO WO PartNo SO Qty Comp Var @MatQty
12.12.07 12345 54321 0001-00001 5,000 0.16 800
12.12.07 12345 54321 0001-00001 5,000 0.16 800

Due to some parts requiring 2 Component Material Required to
produce the finished part no 0001-0001, then everything in DETAILS section is listed twice (DUPLICATED) 2 lines with the same thing.

I have modified the Group Footer and placed Stock.PartNo from the database field and this works as it should for Total Stock.Qty on Hand

The problem this creates is causing the duplication of rows in the details now because this particular part requires 2 Stock Materials to make a finished Part.PartNo.

So for each WO it thinks it should show everything twice.

How do I remove the duplicate line? I can't use "Select Distint Records" because it is Grayed Out.

Common to each detail line is listed above in a previous explanation which shows everything used.

Thanks for any help on this.

Cheers
Bill

 

[Madawc]

Could you group again, on the duplicated value? Suppress the detail in the new group and just show the group footer value?

Running totals can also be set to count once per group, for any level of group.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10