Select once >=5th record reached for Employee

[AussieLad]

Our HR Manager would like a report listing reasons for 'Unpaid Absenteeism' in a financial year, once an employee has totalled 5 such days.
Layout is as follows...
Grp1 = Department
Grp2 = Section
Grp3 = Employee Name, (showing Job Title, etc)
Dtls= Absenteeism Description, Date, Hours

The data is NOT to display for any employee UNTIL he/she has accumulated 5 days... then ALL days are to display for that person for the year.

I've been playing with a few ideas, such as...
1) creating formulas to count and reset count after each Grp3, and selecting where count >= 5, but am getting 'formula has to be evaluated after' warnings.
2) 'Suppressing' data, but don't think I'm on the right track there.

Expert advice would be greatly appreciated.

 

[lupins46]

I'm assuming each record in the report is an 'absentee'record
If you group on employeeid, insert a summary to count the records and then use the select expert to select groups where the summary total is >=5 you should get what you want.

 

[lbass]

You would go to report->edit selection formula->GROUP and enter:

count({table.emplID},{table.emplID}) >= 5

//where you have a group on {table.emplID}

This requires that you limit your records in the RECORD selection formula to those for absences.

-LB

 

[AussieLad]

Thank You both to 'lupins46' and 'lbass'... simple when you know how, isn't it.
Much appreciated.