Filtering based on result of Sum

Hi,
Hello to all, I'm kinda new, kinda in a way where I lurked for past 6 months, learned a lot but now it's time to actually ask questions :)

I'm working with Jet Essentials 15, and NAV2013.

I need to write a theoretically simple report which will look at NAV's Warehouse Entry Table.

The report needs to bring rows with 'Item no.' and sum for all adjustments which are made for this item.
Conditions are
1) 'Reason Code' field must equal 'PRERECEIPT'
2) 'Zone Code' must be other than 'ADJUST'
3) Sum of field 'Quantity' must be other than '0' (zero) for that specific 'item no.' <– this is the bit which I'm having trouble doing

Phew.

It's beyond my capability, not sure if even possible, but looking at some of the formulas you people write, it might be possible and dead simple.
I could obviously list all the items adjusted with that reason code, do a sum of adjustments, and conditionally hide the lines where sum would equal zero, but I was wondering if there is a more elegant solution..

Thanks!