Skip to Content
Author's profile photo Former Member

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 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

Assigned Tags

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