My report is designed to display only those multiple part #s that are the same (by group) across multiple jobs (jobs are listed in the detail section).
It works fine, EXCEPT it ALWAYS displays a lone part # (not repeating) at the top of the report along with the only job for that part. I think I need to add something to the formula to take care of this "orphaned" part #, but not sure what that would be.
My suppress formula that I use for the group and details section is:
IF previous({OrderDet.PartNo}) <> {OrderDet.PartNo}
AND next({OrderDet.PartNo}) <> {OrderDet.PartNo}
THEN TRUE
ELSE FALSE
Any ideas? Thanks in advance for the help!!
