Getting records in a Group for "maximum" value of a particular field 1

[sikar]

In my report there is a group.In the group there is a field which will have only two values.Out of those two values i have to pick records for the maximum value only.i have put all the fields to be shown in the 'details Section'.
Please help me to do this.I tried to use 'maximum' in the GroupSelectionFormula but it asks for a boolean value.

thanks
sikar

 

[MASTERMIKE]

Write a formula using "maximum ({table.field of the field you are looking for}, {table.field of the group})". Place this formula in the report and it should return the maximum value within each group.

 

[lbass]

Your group selection formula should look like:

{table.value} = maximum({table.value},{table.yourgroupfield})

This will return the entire record containing the maximum value.

-LB