Onfirstrecord by group?

I need to perform an expression on the first record of each Group. So i need to identify such. By using Onfirstrecord if can get the first record in the report but i need it by group.
My report is grouped by Employee name
Tom_cfglendingAsked:
Who is Participating?
 
OutinConnect With a Mentor Commented:
Several solutions are possible.

This could help:
  if onfirstrecord or
 {EMPLOYEE_NAME} <> previous({EMPLOYEE_NAME}) then 'First record in group!'

Or you could create a running total that counts records and resets when the group changes....then whenever the running total = 1, you're at the first record of the group...

--
Outin
0
 
MIKESoftware Solutions ConsultantCommented:
Try using the MINIMUM function....

MINIMUM({Yourtable.Field})

MikeV
0
 
bdreed35Commented:
Either of Outin's solutions will give you the result you are looking for.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.