hide rows based on condition

[juffin]

I have a report which has columns A and B
Column A is grouped and Column B has numeric values
A total(sum of column B) is made for each group(column A)
My question is once a total is zero for a group
entire group should not be displayed in the report.

Column A    Column B
-----------------------
A           -10
       -20
       +30
total        0
-----------------------
B         +10
       -20
       +5
total        -5
-----------------------

only group B should be displayed in the report..

Thanks in adv for any ideas...
jf

[MFGF]

Hi,

Retrieving then hiding these rows seems like an inefficient way to achieve your requirement. It would be more efficient and far easier to code a summary filter with the expression [Column B] > 0 and with the Scope setting defined as Column A.

Cheers!

MF.