Have a report where I have grouped the report based on a transaction number.

So each transaction number could be 1 line, 5 lines, 10 lines whatever.

For each detail line in the transaction I have created a formula based on another field to return either a '1' or a '0'.

The majority of the detail lines in the groups will return a zero and hence the group total is zero. Some of the groups will return a number greater than zero since some of the detail lines in that group return a 1. For those groupings that return a number greater than zero I want to throw away all detail lines even though the detail lines within that grouping could contain 0's or 1's.

For example:

Trans #       Return Value

12345        0
12345        0
12345        1

Group Total = 1

In the above example I want to throw away all three detail lines since one of them returns a value greater than zero.

Any suggestions?

Thanks lockwelle for your reply. No just the opposite. I only want to keep the 0's. So if any line in any group contains a '1' I want to throw them all out even if the other lines are zero.

So in my case all lines have to be '0' otherwise I don't want those group of lines.

Hope this makes sense.

Thanks lockwelle will give that a shot didn't think of going that route.

Will keep you posted.

Thanks DBlank and lockwelle for your input. I must admit I feel like an idiot since the solution was staring me straight in the face the whole time.

I created a formula as mentioned to add a number to the groups and if > than 0 I wanted it eliminated.

So I "simply" used the Selection Formulas but instead of using the "Record" option used the "Group" option instead and indicated I only wanted Groups that equaled zero and problem solved.

Thanks again for your input.