Getting the values of the maximum record

[maas]

Hello,

I am facing some difficulties while developing a report. The problem is that I am getting a number of values in the Details section and I want only to display the record which it is having the maximum event number for each group (one record to be shown for each group).
My report structure is:
GH1:{Deal_NO} 1 -- Suppressed
Details:{Deal_NO} {Amount} {Event_no} {Comments}
1 1000 222 Rate
1 2345 655 Principal
1 444 111 Sell
GF1: {Deal_NO} -- Suppressed

So, my result will be:
1 2345 655 Principal.

So, please instruct me on how to do that.
I tried to define in the Group Selection under Select Expert:
{Event.Event_no}=maximum({Event.Event_no},{Deal_No}), but some deals were disappeared.
Thanks

 

[crogers111]

Not in a place to test, but this should work.

Add a Grouping on {Event_no}
place your fields in GF2

This should show records for the largeest (maximum) Event_No per deal.

 

[crogers111]

...and suppress details sections

 

[maas]

Thanks and I will try your solution