petejigsaw
MIS
Hi
I have been struggling for several weeks on a report that I need to get finished, yet just can't get to work as it should. Essentially, I am trying to work out how to suppress a group based on the presence of BOTH specified values in the details section. Here is some example data, showing the groups of data as they are so far - grouped on Order No.:
Order = 45674567[Supplier = 180005 Product = WARDTREF123
Order = 45674567 Supplier = 180005 Product = CHEST12345
Order = 1234567 Supplier = 180005 Product = CHEST567809
Order = 1234567 Supplier = 0 Product = PREXMASPREF
Order = 3564896 Supplier = 0 Product = PREXMASPREF
Basically, I want to suppress the Order No. group in all cases except where there is a product by supplier 180005 AND supplier 0, but only where supplier 0's product code is PREXMASPREF. In the above item, that means that of the 3 example groups, only the middle one would still show.
I have tried all sorts of formulas to give 1 or 0 for each individual condition and then use them to create summaries, but I always end up with some anomolies.
Any helps gratefully appreciated!
Many thanks
Petejigsaw
I have been struggling for several weeks on a report that I need to get finished, yet just can't get to work as it should. Essentially, I am trying to work out how to suppress a group based on the presence of BOTH specified values in the details section. Here is some example data, showing the groups of data as they are so far - grouped on Order No.:
Order = 45674567[Supplier = 180005 Product = WARDTREF123
Order = 45674567 Supplier = 180005 Product = CHEST12345
Order = 1234567 Supplier = 180005 Product = CHEST567809
Order = 1234567 Supplier = 0 Product = PREXMASPREF
Order = 3564896 Supplier = 0 Product = PREXMASPREF
Basically, I want to suppress the Order No. group in all cases except where there is a product by supplier 180005 AND supplier 0, but only where supplier 0's product code is PREXMASPREF. In the above item, that means that of the 3 example groups, only the middle one would still show.
I have tried all sorts of formulas to give 1 or 0 for each individual condition and then use them to create summaries, but I always end up with some anomolies.
Any helps gratefully appreciated!
Many thanks
Petejigsaw