Skip to Content

Display only the last record or first record in a group

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

Design Before Change.JPG

Preview

Preview Before Change.JPG

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,

Design After Change.JPG

Preview After Change.JPG

To display the first record in the Group,

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

Be the first to leave a comment
You must be Logged on to comment or reply to a post.