I have a report where I need to suppress 0 balance. what happen is that I do not have a unique field where I can group by.

here is my data

Cust#           Name        amount
0205            sample1       25            
0205            sample1       30
0205            sample1      -30
0205            sample1       17
0204            sample2       10
0204            sample2      -10
0204            sample2       -5

I have to accomplish this

Cust#           Name        amount
0205            sample1       25            
0205            sample1       17
0204            sample2       -5

could someone please help me?

Gracias, that worked great.

Edited by otto - 20 May 2014 at 4:32am