Last Record in Group

[Smithsc]

Is there any functions similar to "OnLastRecord" that can calculate the last record of a group.

 

[IanWaterman]

Group report as required, then sort data to ensure last record in group set is the one you want.

Copy data from detail into Group footer and suppress detail.

Ian

 

[lbass]

If you only want to use some value in the last record of the group in a calculation, you can use a running total and in the evaluation section, use a formula:

onlastrecord or
{table.groupfield} <> next({table.groupfield})

-LB