Display only the last record or first record in a group

[Former Member]

Consider a scenario as follows,

The Customer with the maximum Spend_Amount needs to be displayed within a particluar State

In such a case,The records are refreshed against the DB and in the report level grouping is applied on the State and the Spend Amount is sorted in ascending order

Preview

To Display only the last record in this group,

1.Place the fields which are present in the Details section to the Group Footer Section

2.Suppress the Details section , as below,

To display the first record in the Group,

1.Place the fields in the Group Header Section and suppress the Details section