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

 

[lbass]

You haven't said what you want to happen or what the issue is. How would you want the above sample to display?

-LB

 

[DJWheezyWeez]

I found my solution. I used {table.Customer} = next({table.Customer}) in the Suppression formula. It got rid of the first two HOL lines.