suppressing specific lines

[DJWheezyWeez]

I'm using CR XI.

Normally I find some other field that I can use and do a (table.field} = maximum({table.field}, {group}) type thing but I am not able to do this here. I have:

Customer Sales
BRD 10
DTK 5
HOL 5
HOL 10
HOL 15
ULD 1025
I know I don't have the right syntax but I tried something like this in the Selection Expert in the Suppress formula:
not onlastrecord when {table.Customer} = "HOL"

Am I close with that formula or not at all or is there not a way to do what I want?

-DJWW

[BrianL]

Hi DJWW,

Not sure exactly what you're trying to do here. In the data you've listed, which lines are you trying to suppress/not suppress?

Thanks,
Brian

[DJWheezyWeez]

Oh sorry, I'm trying to suppress the first two lines of customer HOL but I found my answer. I used {table.Customer} = next({table.Customer} in the suppression formula.