jbecker614
Technical User
Crystal XI
Report is off of MS Excel Data
Currently have a report that lists employee records of hires. The report lists employees that could have worked for several different companies. I need to suppress records where all of the records indicate that the employee is terminated.
The key for the suppression will be the terminated date. I need to suppress records when all of the specific employee detail lines have a terminated date. If the employee has at least one null value for the terminated date, I would need to show all records for that employee.
Sample layout:
2 records; employee termintated on both records, I would need to suppress this entire employee from the report
Emp# Hire Date Term Date
001 10/01/2001 12/31/2003
001 11/23/2005 06/30/2006
3 records; employee terminated on 2 records but not on the third. I would need to show all records for this employee.
Emp# Hire Date Term Date
004 01/01/1999 12/31/2002
004 01/01/2004 06/30/2004
004 01/01/2006 (blank or null value)
I should add that there is currently a suppression formula for the details that is suppressing records for employees that have only one record. This utilizes a counting summary in the group footer and suppressing the details section when the count is less than 2.
Any suggestions? Appreciate any and all help. Can post further details if needed
Report is off of MS Excel Data
Currently have a report that lists employee records of hires. The report lists employees that could have worked for several different companies. I need to suppress records where all of the records indicate that the employee is terminated.
The key for the suppression will be the terminated date. I need to suppress records when all of the specific employee detail lines have a terminated date. If the employee has at least one null value for the terminated date, I would need to show all records for that employee.
Sample layout:
2 records; employee termintated on both records, I would need to suppress this entire employee from the report
Emp# Hire Date Term Date
001 10/01/2001 12/31/2003
001 11/23/2005 06/30/2006
3 records; employee terminated on 2 records but not on the third. I would need to show all records for this employee.
Emp# Hire Date Term Date
004 01/01/1999 12/31/2002
004 01/01/2004 06/30/2004
004 01/01/2006 (blank or null value)
I should add that there is currently a suppression formula for the details that is suppressing records for employees that have only one record. This utilizes a counting summary in the group footer and suppressing the details section when the count is less than 2.
Any suggestions? Appreciate any and all help. Can post further details if needed