you can do in this way.
1. group the records on employee id.
2. sort the records in employee id, attendance date order
3. create a formula "initval" to declare a shared variable syntax as follows
shared stringvar absrec :="";
4. place this initval in group header of employee id so it initalized to blank for every employee id
5. create one more formula "checkabs" to check continous absentiee for
more than 7 days. formula has following syntax
if datediff("d",previous(<datefield>),<datefield>) >= 7
and
previous(<empidfield> = <empidfield>) then
shared stringvar absrec := "A";
6. Now store the value of this share variable in one more formula "abs" having folowing sytnax
shared stringvar absrec;
7. so if any employee is absent for 7 days the value of "abs" will be "A".
8. now you can supress the employee group id footer based on the values of "abs".
i.e conditional supressing syntax
abs <> "A".
Let me know if you get any error.
IP Logged
