Simpler way to compare items?

[BIGGY]

I have a way to do this, however it's fairly long at this point to get everything set up. I was curious if anyone had ever done anything like this before and had a shortcut.

I have in total 6 units that print under each customer. Unit1, Unit2, etc...
The idea is that Unit1 and Unit2 should be compared, then Unit3 + Unit4, and finally Unit5 and Unit6.

So the idea is that if Unit1 and Unit2 both equal zero, then I should display them both. If one of the units shows as in stock (anything above zero), then do not display either of them. If both units show as being out of stock, then display both. This cannot be done in the detail section by writing suppress formulas because when one line is printed, it cannot compare to another line, correct?

So basically what I'm doing is writing a formula that will flag both items as either being zero or one existing. Then other formulas to display all of the info such as item name, itemID...all which will be displayed in the group footer. Big pain and I'm wondering (but doubting) if anything is being overlooked that's much simpler? Hope this was explained well!

[brucevde]

This cannot be done in the detail section by writing suppress formulas because when one line is printed, it cannot compare to another line, correct?

It is possible to compare values of the current record with those of the Previous or Next record.

Check out the Print State functions in the Formula Editor.