Suppress if Duplicated w/second column

[Juice300x3]

I have a report that shows my part#'s in a bill of material and the subcomponents when a main part# is made up of several smaller parts. I linked with a left outer join from my main BOM to the sub table. Some of my parts in the main BOM have several components that have to be assembled to make up the main part#. I am listing each part# in one column in several detail sections, with the qty needed for each unit. When I suppress my main part# if duplicated, it shows the empty space for it, and the qty still appears. The part# is a string, and the qty is a number. Any ideas on how I can get rid of that entire line of detail when the main part# is duplicated?

 

[lbass]

It sounds like you are using field suppression. Instead, go to the section expert->details->suppress->x+2 and enter:

{table.part#} = previous({table.part#})

-LB

 

[Juice300x3]

Sorry, I didn't go far enough in my explanation. I format the part# field to suppress if duplicated, and go to section expert to suppress if blank section. The problem is that I still have a quantity in that section, and cannot figure out a way to suppress it based on the part# being duplicated. The formula that you gave me would not apply here, because I have multiple detail sections and the duplicated part#'s are not consecutive in the listing.

 

[lbass]

You need to show a sample of your data in the detail section, and then also show how you want it to look in your final report.

-LB

 

[Juice300x3]

Here is what it looks like right now. The main part# is the 64004, and it repeats in all the blanks you see here since all of the other parts are subcomponents that have to be assembled to make a 64004. Since there is still a qty field when I suppress duplicates, the suppress blank section is not working. This is only about 1/4 of the list for 64004, and there are about 200 main part#'s per unit, so it just becomes noise when the duplicates are left in.

PART QTY
64004 1
TO-TU-140 1
1
TO-N-1 2
1
MI-N-3 2
1
TO-O-110 1

I want it to look like this

PART QTY
64004 1
TO-TU-140 1
TO-N-1 2
MI-N-3 2
TO-O-110 1

 

[lbass]

Instead of using suppress if duplicated, select the quantity field->format field->suppress->x+2 and enter:

{table.part#} = previous({table.part#})

If this still doesn't do it, please show your data WITHOUT any suppression and identify the detail sections for each row, as I'm unclear about what you are showing me.

-LB

 

[Juice300x3]

Thanks for your patience. This is my first time utilizing this help. I tried checking out the other posts, but am still unsure what info to provide since I don't speak programmer. Here is what the report looks like with no suppression. Detail columns labeled just like in Crystal. I think I could do it through grouping and summarizing, but I am going to be adding additional fields to the report later on, and am hoping there is a formula that will help get rid of the duplicates.


PART QTY
Da 64004 1
Db TO-TU-140 1
Da 64004 1
Db TO-N-1 2
Da 64004 1
Db MI-N-3 2
Da 64004 1
Db TO-O-110 1
Da 64004 1
Db TO-CC-A140 1
Da 64004 1
Db YW-9-4K 1
Da 64004 1
Db TO-N-5 2
Da 64004 1
Db TO-O-2V 1
Da 64004 1
Db TO-ST-140 1
Dc TO-WA-3 1
Da 64004 1
Db TO-ST-140 1
Dc TO-SR-140 2
Da 64004 1
Db TO-ST-140 1
Dc MC-1 1
Da 64004 1
Db TO-PI-140 1
Dc FD-F-5K 1
Da 64004 1
Db TO-IM-A140 1
Dc BW-90-4G 1
Da 64004 1
Db TO-ST-140 1
Dc TO-SC-140 1
Da 64004 1
Db TO-ST-140 1
Dc TO-WA-2 1
Da 64004 1
Db TO-ST-140 1
Dc TO-HR-140 1

 

[lbass]

I think it is confusing because you are using separate sections. Try showing the data just in the detail_a section. You have a lot of data repeating. Are there three fields you are using plus the quantity field? Try laying it out like the following:

field1 field2 field3 qty

And sort by field 1 and then by field 2 and 3. I'm guessing you could get your desired display through grouping and then displaying results in a group header, but it's hard to tell so far.

-LB