Last record in a group 2

[IanWaterman]

Use a Running total to count a unique for each record in a group reseting on change of relevant group.

Use a formula

@Display
If {#RT UniqueField] = count(uniquefield, groupfield) then 
{table.fieldname}
else 
{table.fieldname}&" OR"

Ian

 

[lbass]

Or you could use a formula like this:

if {table.groupfield} <> next({table.groupfield}) then
{table.field} else
{table.field} + " or"

-LB

 

[lbass]

Actually, that should be:

if onlastrecord or
{table.groupfield} <> next({table.groupfield}) then
{table.field} else
{table.field} + " or"


-LB