Suppress if duplicated

[Juice300x3]

I am working in CRv9 in a manufacturing setting. I have a report that tells me part#'s that we were out of that kept a unit from progressing through manufacturing. Each product that we start machining gets a "tag #". Somtimes, these tag#'s may go on and off of our "set a side" list and then back on again, giving me a multiple entry for the same piece. I want to suppress all but one of the detail lines when this occurs. Does anyone have a suggestion for the formula that I should write to make this happen?

 

[Turkbear]

Hi,
Try grouping on tag#.

This assumes that any one of the multiple tag#s is ok to use to get details for.





To Paraphrase:"The Help you get is proportional to the Help you give.."