Suppress Duplicate Only If Same WO No. 1

[bstafford21]

Using CR 9.2
I have a report that displays in Columns all Daily Work Orders the Part No., Material Issued, the WO Qty, the Qty Stored, Qty Scrapped.

I have been able to set up Running Totals and works great the way I need. Below is the data used.

Date (Ops.Date_of_Completion)
WO (WO.WO_No)
Part (WO.Part_No)
Material (Materials.Part_No)
Mat Iss (Materials.Qty_Issued)
WO Qty (WO.Qty)
Qty Stored(WO.Qty_Stored)
Qty Scrap (WO.Qty_Scrap)
Price (Part.NormSellingPrice)
Scrap Cost(@Scrap Cost) using {Part.Norm Selling Price}*{WO.Qty_Scrapped}
Produced Cost(@Produced Cost) using {Part.Norm Selling Price}*{WO.Qty_Stored}
Total Scrap % (@IndividualScrap%) using if {WO.Qty_Scrapped} = 0 then 0 else 100-(({WO.Qty_Stored}-{WO.Qty_Scrapped})/({WO.Qty_Stored})*100)



I have created a Group for each day using Ops.Date_of_Completion, so now all my Production is grouped for each day showing me the totals using the Insert Summary for Qty Stored and Qty Scrapped. This is in the Group Footer

I also did a Sum of @Produced Cost which has duplicated Sales figures

What I need to do is Suppress any Duplicates, this is caused by WO and Parts sometimes use 2 or 3 materials for making the same part.

I want to suppress duplicates for that WO No. only. Right now of course if I used the suppress option it will suppress anything with the same quantity or scrap values.

Do I need to put a formula in the Suppress if Duplicated x-2 box to suppress on dups for that WO No.

Not sure how to do that, can someone help me.
Thanks for any help and I hope I have given enough information to solve this. I appreciate anyone's time.

Thanks

Bill

 

[MisterMo]

you could create a composite field which is made of WO and Parts and then group by it, this should get rid of dups.

Mo

 

[bstafford21]

Hi Mo,

I have gone to the Format Field / Common / Suppress If Duplicate / X-2 Formula field and put in the following to Suppress only Duplicates of that WO and not other WO's.

previous({WO.WO_No}) = {WO.WO_No}

It seems to work and only suppressed the Values for that WO that are duplicated.

I used this in all Fields where duplicates would occur:

Is this correct to use this formula?

Thanks

Bill

 

[MisterMo]

That is correct but you said that th problem was caused by two fields

this is caused by WO and Parts sometimes use 2 or 3

your solution is better suited on the details section and place your formula on the X2 for the suppress option.

or simply group by {WO.WO_No} and drag all your fields on the header or footer of that group and suppress the detail section

Mo

 

[bstafford21]

Hi Mo,

Yes your right I did say WO & Part, only because I thought both may be affecting it. I then realized that WO was common to all of the detail data and then just quessed at the formula until it worked.

Unfortunately I do not understand why the formula works, I only assume, dangerous for me to do, that if Previous WO is equal then to do what?

Thanks for the help and confirmation, it is much appreciated and problem is solved and it is working fine.

Thanks

Bill