Remove Duplicate Information

[bstafford21]

I am using Crystal 9 and have a report based on Production Jobs, which includes the following:

Part No. Due Date Material Family Grp
(WO.PartNo) (WO.EndDate) (Components.) (Routes.FamilyGrp)


WO SO Order Qty
(WO.WONo) (WO.SONo) (WO.Qty)


My problem is some of my Work Orders (WO.WONo) have more than 1 component. Some parts have 2-3 material components.

I can suppress the additional info with no problem, but that is no good because the Family Grps are still there. I need to show only the main 1st component and then only the Family Grp for that. There is not a need to see this 3 times for example if I have 3 components, then the same Family Grp (These are Process Machines) they keep showing up. Needless to say the report is long and with alot of duplication for each component.

How do I remove the other components of that WO.WONo so things are not duplicated?

Appreciate any help on this one please.

Thanks

Bill

 

[IdoMillet]

You can group on WO, sort within that group so the main component is always at the top, and display the fields in the Group Header (suppress the detail section). The Group Header always shows the information from the 1st record within the group.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[bstafford21]

Hello IdoMillet,

Thanks for the reply. I have changed the report, before I did Group by WO.PartNo.

I now tried your suggestion and did Group by WO.WO

This has worked and now shows only the first line only.
My question is how would I still show the other process steps that goes to that WO.WO, it is only showing step 1

I may need another alternative, but here is how my data on the report would look like with Group By WO.PartNo


Part No. Due Date Material Family Grp WO SO Order Qty
0002-01066 17/05/06 EPT-10 SHC 1234 4321 5,000
VT
FA
PA
X-Box-06 SHC
VT
FA
PA

As you see my report using Group By WO.PartNo shows there is 2 material components it takes (1. EPT-10) (2. X-Box-06)

However they show the same duplicated Family Grp data.

When I did it for Group By WO.WO all I obtained was just line 1 and not showing the other Family Grp data that is part of that WO.

What should I do to remove duplicate Family Group and remove the other materials when more than one material is used?

I hope I explained this well enough.

Thanks

Bill

 

[IdoMillet]

Whatever you wish to show only one of, group on the level immediately above it.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[bstafford21]

Sorry but I do not understand what you mean, but here is what I think you are trying to tell me.

What I did was:
Main 1st Group = WO.WO
Next 2nd Group = Family Grp

Now I have only my Family Groups showing as I need them, so the other components are not showing and only the Family Grp (Machine Process Steps) are showing as I need.

However with the sorting options I have in the Group Expert, I cannot get the Family Grp (achines Process Steps) in the Correct order,because my only choices are Ascending, Descending, original & specified.

So I can't specify the order otherwise they are all in the same order and that is not correct.

Doing the Original order goes back to showing all Family Grps for each material component again.

Doing Ascending or Descending just changes the order Alphabetically. So how do I control this if using the Family Group in the 2nd Field below the WO.WO Main Grp?

Everything works in the report now doing as you said, only if I understood correctly, just the order of the Machine Process steps are the problem now.

Bill